Spreadsheet+L+2

**Lesson Two: Using Formulas**

In several of the activities in this module you will again be asked to use your imagination. In this lesson, we will be pretending that you have been hired by a popular car dealership to count the numbers and colors of cars that pass by during a week (it is just a summer job, not a career). The dealership will then use this data to determine the most popular colors for their 2008 order. After a week of careful observation, you are ready to report your results. Unfortunately you spilled coffee on the napkin you were using as a tally sheet. Enter the following data into a spreadsheet and then use a formula to find the sum for each day and for each color.   To calculate the totals you must use a formula. To do this you must first select the cell in which you want the answer to go and then type in the correct formula.
 * Colour || Monday  || Tuesday  || Wednesday  || Thursday  || Friday  || Total  ||
 * Red || 3 || 6  || 2  || 1  || 11  || ||
 * Green || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">14 || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">18  || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">15  || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">16  || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">12  || ||
 * <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">Blue || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">32 || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">11  || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">14  || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">19  || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">6  || ||
 * <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">Yellow || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">0 || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">4  || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">2  || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">5  || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">3  || ||
 * <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">Black || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">24 || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">19  || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">16  || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">24  || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">12  || ||
 * <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">White || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">144 || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">62  || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">179  || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">328  || <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">11  || ||
 * <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">Total || || || || || || ||
 * <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">Total || || || || || || ||

The formula for finding the sum Is
 * <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">=sum(range) ||

<span style="FONT-FAMILY: Arial, Helvetica, sans-serif">where the range is the group of cells that you want added. <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">example =sum(A1:A4) would add up the cells A1+A2+A3+A4 <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">You want to calculate the sum of each color of car, and have it appear in column H. Click in cell H3, which will be the total for the color red. Type the following <span style="FONT-FAMILY: Arial, Helvetica, sans-serif"> <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">Repeat this step for all of the colors. <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">Create another formula in cell B10, totaling the number of cars for Monday. repeat this for the other days of the week. <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">In cell H10, add up the numbers from column H. This will be the total number of cars that have been counted. An alternative would be to count all of the numbers in row 10. This would give you the same number. <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">Make sure that you calculate an overall sum by adding the daily totals or the color totals in cell H10. Do not add up both daily total and color totals, or you will have twice the correct answer. <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">*Hint: Be sure to include the equal sign, both brackets, and the full colon
 * <span style="FONT-FAMILY: Arial, Helvetica, sans-serif">=sum(B3:F3) ||