Microsoft Office Professional 2010 Step by Step eBook

306 Chapter 10 Perform Calculations on Data

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. 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. 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. In the Formula Auditing group, click the Evaluate Formula button.

The Evaluate Formula dialog box opens.

The dialog box displays the formula from cell D21.

16. Click Evaluate three times to step through the formula’s elements, and
    then click Close.
    The Evaluate Formula dialog box closes.