Microsoft Office Tutorials and References

In Depth Information

**Finding and correcting errors in calculations**

12

On the
Formulas
tab, in the
Formula Auditing
group, click
Remove Arrows
to hide

the arrows.

13

In the formula box, delete the existing formula, enter
=C12/D20
, and then press

Enter
. The value
14%
appears in cell
D21
and the change is reflected in the Watch

Window.

14

Click cell
D21
.

15

On the
Formulas
tab, in the
Formula Auditing
group, click the
Evaluate Formula

button to open the
Evaluate Formula
dialog box, which displays the formula from

cell
D21
.

16

Click
Evaluate
three times to step through the formula’s elements, and then click

Close
to close the
Evaluate Formula
dialog box.

17

In the
Watch Window
, click the watch in the list.

18

Click
Delete Watch
to erase the watch.

19

On the
Formulas
tab, in the
Formula Auditing
group, click
Watch Window
to close

the
Watch Window
.

CLEAN UP
Close the ConveyerBid workbook, saving your changes if you want to.