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

Vehicle Loading and Cost sections with formulas displayed in the cells

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.