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 Errors)

Tracing Errors What Does an Error Look Like? Here is a simple example we can try.   Before You Begin: Set Up a Mistake Select Cell E8 and type: 360 Now Cell E8 does NOT have a formula. Yet, how would you know?   3 Try This: Trace the 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. What Do You See? You should see arrows in each Row that trace the formulas. You should see a "gap" in the tracings. This gap indicates that there is no formula in Cell E8. Keep going....