Microsoft Office Tutorials and References
In Depth Information
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 Chapter03 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.
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. On the Formulas tab, in the Formula Auditing group, click the Trace Precedents
A blue arrow begins at the cell range C3:C7 and points to cell D8, indicating that
the cells in the range C3:C7 provide the values for the formula in cell D8.