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