Exam 77-427 Microsoft Excel 2013 EXPERT 1. Manage and Share Workbooks 1.3   Manage Workbook Changes: Identify Errors       Find the Mistakes 3. Here is an example of an error In the example on this page, the Range for the Revenue is wrong. It is E1:E71. The Range should be E1:E70. You can re-create this error if you wish by editing the REVENUE with the Name Manager.   What Do You See? When the Range is wrong, you may see: "#VALUE!"   What Else Do You See? You may also see an Information (!) alert. 4. Try This: Audit the Formula When you select the Cell that says #VALUE! you should see an outline of the data that is used in this calculation.   In this mistake, the RANGE for the REVENUE includes the formula in Cell E71. This is called a Circular Reference: where one formula requires the result from another, but that formula needs the result from the first.

Formula -> Formula Auditing ->Trace Precedents