Microsoft Office Professional 2010 Step by Step eBook

304 Chapter 10 Perform Calculations on Data

In this exercise, you’ll use the formula-auditing capabilities in Excel to identify and

correct errors in a formula.

SET UP You need the ConveyerBid_start workbook located in your Chapter10 practice

file folder to complete this exercise. Open the ConveyerBid_start workbook, and save

it as ConveyerBid. Then follow the steps.

1. Click cell D20.


2. On the Formulas tab, in the Formula Auditing group, click Watch Window.

The Watch Window opens.

In the Watch Window, you can monitor the results of selected formulas.

3. Click Add Watch, and then in the Add Watch dialog box, click Add.

Cell D20 appears in the Watch Window.

4. Click cell D8.

=SUM(C3:C7) appears in the formula bar.

5. In the Formula Auditing group, click the Trace Precedents button.

A blue arrow begins at the cell range C3:C7 and points to cell D8.