Which Excel command opens the Evaluate Formula dialog in the Formula Auditing group?

Which Excel command opens the Evaluate Formula dialog in the Formula Auditing group?

• A. The "Evaluate" button is under the Review tab.
• B. The command is "Evaluate Formula" on the Formulas tab in the Formula Auditing group.
• C. "Trace Precedents" tool in the Formulas tab.
• D. "Show Formulas" in the Formulas tab.

Answer: (B)

When you want to understand exactly how a formula is calculated, you use the tool that opens a dedicated dialog to step through the evaluation. This dialog shows the formula, lets you apply it piece by piece, and displays the result of each subexpression as you go, making it ideal for debugging complex formulas. In Excel, this tool is located on the Formulas tab, within the Formula Auditing group, and is named Evaluate Formula. Selecting it brings up the interactive dialog that guides you through the calculation. Other options in the Formula Auditing group perform different tasks: Trace Precedents shows arrows to cells that contribute to the formula, and Show Formulas toggles whether cells display formulas or their results. Neither of these opens the Evaluate Formula dialog, which is why this command is the correct choice.

When you want to understand exactly how a formula is calculated, you use the tool that opens a dedicated dialog to step through the evaluation. This dialog shows the formula, lets you apply it piece by piece, and displays the result of each subexpression as you go, making it ideal for debugging complex formulas.

In Excel, this tool is located on the Formulas tab, within the Formula Auditing group, and is named Evaluate Formula. Selecting it brings up the interactive dialog that guides you through the calculation.

Other options in the Formula Auditing group perform different tasks: Trace Precedents shows arrows to cells that contribute to the formula, and Show Formulas toggles whether cells display formulas or their results. Neither of these opens the Evaluate Formula dialog, which is why this command is the correct choice.