Formulas -> Formula Auditing->Error Checking

Exam 77-427 Microsoft Excel 2013 EXPERT
1. Manage and Share Workbooks
1.3   Manage Workbook Changes: Identify Errors

no

Error Checking

Error Checking works like Spell Checking. Errors can be marked and corrected one at a time, or Live, as you work on your formulas.

 

1. Before You Begin: Make a Mistake

Select Cell E8.

Enter this formula: =C7*D8.

 

What Do You See? This formula does NOT match the formula above or below it. So, Cell E8 has a error mark, a small triangle in the upper left corner.

 

Keep going, please...

graphic3
graphic2
graphic1