graphic3
graphic2

Formulas -> Formula Auditing->Trace Precedents

Exam 77-427 Microsoft Excel 2013 EXPERT
1. Manage and Share Workbooks
1.3   Manage Workbook Changes: Troubleshoot With Tracing (Trace Precendents)

no
graphci1

Formula Auditing

2. Try it: Trace Precedents

Select Cell E29.

Go to Formulas->Formula Auditing.

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

 

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.

graphic4