Excel: Sounds Good Page 1 2 3 4 5 6 7 8 9 10 11 12 13

Check Your Work In the previous pages, we double clicked on a cell to trace the references in the equation. There is a more sophisticated method for examining your work. On the Formulas Ribbon, go to Formula Auditing. There are some useful tools available:   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 the Arrows Formulas -> Formula Auditing