Formulas -> Formula Auditing->Error Checking->Options Exam 77-427 Microsoft Excel 2013 EXPERT 1. Manage and Share Workbooks 1.3   Manage Workbook Changes: Identify Errors

Error Checking Rules Error Checking Rules can be found by clicking on the Options button when you are in the Error Checker.   3. Try This: Review the Options The Error Checking is still open. Click on Options.   What Do You See? Error Checking is enabled by default.   The Error checking rules include: Cells that result in an error Inconsistent formulas in tables Years that are only 2-digits Numbers formatted as Text Formulas which omit cells Unlocked cells which have formulas Formulas that refer to empty cells Data that is invalid Click OK to CLOSE the Error Checking Options. Cell E8 still has an error. Click Copy Formula from Above to fix it. Then CLOSE the Error Checking window to return to the spreadsheet.