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