|
You can
evaluate formulas in Microsoft Excel. The little formula auditing
tool has some interesting capabilities. 3.
Consider This: Evaluate a Formula In the
example on this page, the formula refers to several cells that are
calculated in a different spreadsheet. When a cell reference, such
as Cell H11, is highlighted, you can Step Into the cell and
look at the formula that goes with it.
Formulas ->Formula Auditing->Evaluate Formula
Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.2. Enforce precedence: Order of
Evaluation
|
|
| |
