Select Totals, and then the SUM option that highlights the right column (see Figure 3.5).
In future exercises, we will use other options.
This time we will be using the Totals option.
When you click on it, you will see that there are a number of different options.
In the lower right corner of your selection, you will see the Quick Analysis tool (see Figure 3.4).
In this exercise we will use it to insert the Total Points for each student in Column O.īe sure to press Ctrl ~ to return your spreadsheet to the normal view (the formula results should display, not the formulas themselves). The Quick Analysis Tool allows you to create standard calculations, formatting, and charts very quickly. Figure 3.3 Relative References – Displayed as calculations. Pressing Ctrl ~ a second time will display your calculations in the default view – as values. Want to see all the calculations you have just created? Press Ctrl ~ (See Figure 3.3.) Ctrl ~ displays your calculations (formulas). You wouldn’t want column N to display an answer that uses the values in column L. These cell references are relative references.īy default, the calculations that Excel copies change their cell references relative to the row or column you copy them to. The calculation in column B reads: =MAX(B5:B24). Note that as you copy the calculation from one column to the next, the cell references change.
Now, use the Fill Handle to copy the calculation from Column B through Column N.
Select the range of numbers above row 25.
You can either keep typing ( or double click MAX from the list.
Start typing =MAX (See Figure 3.2) Note the explanation you see on the offered list of functions.
Go to the Grades sheet, which is the second sheet from the left at the bottom of your Excel interface.
Open the data file CH3 Data File and save the file to your computer as CH3 Data.
– Review the use of Absolute cell reference in a division formula.īefore we move on to the more interesting calculations we will be discussing in this chapter, we need to determine how many points it is possible for each student to earn for each of the assignments. – Use the Smart Lookup tool to acquire additional information about percentage calculations.
Examine the Quick Analysis Tool to create standard calculations, formatting, and charts very quickly.
Review the use of the =MIN, MAX, AVERAGE functions.