Microsoft Office Tutorials and References

In Depth Information

9.
Click
Next
.

Excel displays a message box indicating that there are no more errors in the

worksheet.

10.
Click
OK
.

The message box and the Error Checking dialog box close.

11.
On the
Formulas
tab, in the
Formula Auditing
group, click the
Error Checking

arrow, and then in the list, click
Trace Error
.

Blue arrows appear, pointing to cell D21 from cells C12 and D19. These arrows

indicate that using the values (or lack of values, in this case) in the indicated cells

generates the error in cell D21.

12.
On the
Formulas
tab, in the
Formula Auditing
group, click
Remove Arrows
.

The arrows disappear.

13.
In the formula box, delete the existing formula, type
=C12/D20
, and press Enter.

The value
14%
appears in cell D21.

14.
Click cell
D21
.

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

button.

The Evaluate Formula dialog box opens, with the formula from cell D21 displayed.

16.
Click
Evaluate
three times to step through the formula’s elements, and

then click
Close
.

The Evaluate Formula dialog box closes.