Practice Exercise 10: Customize a table by applying the Total Row feature
STEP 2: Locate the small dark mark in the bottom-right corner of cell C13 (FIGURE 2).If you move mouse near this mark, your mouse symbol will turn into a slanted double-headed arrow. (The double-headed arrow you see on your PC will be much smaller. You might want to consider increasing the zoom to see it better).
STEP 3: Click and drag your mouse downward to add a row (FIGURE 3). STEP 4: You will see a dark border surround the table, including the new row (FIGURE 4). |
FIGURE 2
FIGURE 3
FIGURE 4
|
STEP 7: Click on cell C14, “668,600.00”. Click on the black, downward pointing arrowhead to see a drop-down menu. You have various options to choose from; SUM is the default.
Select Average (FIGURE 7). Cell C14 now shows the average of the “Actual” column. Select Undo to change back to SUM. |
FIGURE 7
|
This is the end of this section. To continue, go to Module 2 Section 2.4 Customizing a Table Using Formulas in Tables; Practice Exercise 11