Which formula auditing tool can you use to display the value of each part of a formula?
A) Trace Precedents
B) Trace Dependents
C) Evaluate Formula dialog box
D) Formula Validation

Question

Quizplus · Accepted Answer

The Evaluate Formula dialog box allows you to step through a formula and see the value of each part of the formula, making it easier to identify errors or logic flaws in complex formulas. Trace Precedents and Trace Dependents highlight the cells that are used in or depend on a formula, respectively. Formula Validation checks the accuracy and completeness of a formula, but does not display the value of each part of the formula.

Which Formula Auditing Tool Can You Use to Display the Value