Audit Your Work

You can double click on a cell to trace the references in the formula. Here is a better way to audit your spreadsheet.

 

Try This: Trace the Dependants

Select Cell B3.

Go to Formulas->Formula Auditing.

Click on Trace Dependents.

 

What Do You See? There are some useful tools for Formula Auditing:

 

Trace Precedents
Finds the cells that have an affect on the cell you selected

 

Trace Dependents
Locates the formulas that use this cell in their equations

 

Remove Arrows

Formulas -> Formula Auditing->Trace Dependents

Exam 77-888: Microsoft Excel Expert 2010

2. Applying Formulas and Functions

2.1. Audit formulas: Trace Dependents