Formulas -> Formula Auditing->Error Checking->Options Error
Checking Rules can be found by clicking on the Options button
when you are in the Error Checker.
Try
This: Review the Options Go to
Formulas -> Formula Auditing-> Error
Checking. 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
Exam 77-888: Microsoft Excel Expert
2010
2. Applying Formulas and Functions
2.1. Audit formulas: Error Checking
|
|
| |
