Formulas -> Formula Auditing->Trace Precedents

Formula Auditing

Try it: Trace Precedents

Select Cell E25.

Go to Formulas->Formula Auditing.

Click Trace Precedents. You will see an arrow from Cell E25 to Cell E6. 

 

Click Trace Precedents again.

You should see arrows in each Row that trace the formulas.

Click
Trace Precedents a third time.

You will see a call out to each variable in Cells B1, B2 and B3. 

 

Please click on Remove Arrows to take off the tracings.

Exam 77-888: Microsoft Excel Expert 2010

2. Applying Formulas and Functions

2.1. Audit formulas: Trace Precedents