Microsoft Office Tutorials and References
In Depth Information
EXTENDING THE EXAMPLE
FIGURE D-30
Formulas from row 20 copied into rows 21 and 22
their formulas need to be updated to include
rows 21 and 22. To quickly check which cells you need to update, display the formulas in the Totals row.
Hold down the Ctrl key and press the ~ key; on most keyboards, this key is near the upper-left corner next to
the
Note that most cells in the Totals row have not changed
1
key. The Vehicle Loading and Cost sections now display formulas in the cells (see Figure D-31).
FIGURE D-31
You must update any Totals cells that do not include the contents of rows 21 and 22. For example, you
need to update the Totals cells H23 through L23 and cell N23. Cell M23 is not really a total; it is a cumulative
ratio formula, so you do not need to update the cell. Use the following formulas to revise the Totals cells:
￿
Cell H23:
SUM(H16:H22)
¼
￿
Cell I23:
SUM(I16:I22)
¼
￿
Cell J23:
SUM(J16:J22)
¼
￿
Cell K23:
SUM(K16:K22)
¼
￿
Cell L23:
SUM(L16:L22)
¼
￿
Cell N23:
SUM(N16:N22)
¼
The updated sections should look like Figure D-32.

Search JabSto ::

Custom Search