Formulas -> Formula Auditing->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
|
|
| |
