Formulas -> Formula Auditing->Error Checking

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.


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...

Exam 77-888: Microsoft Excel Expert 2010

2. Applying Formulas and Functions

2.1. Audit formulas: Error Checking