basic computer MCQ #264

When working with formulas in Excel, how can you see the intermediate results of a calculation before the final answer is displayed?

basic computer MCQ #264

  1. Question 1

    Q1. When working with formulas in Excel, how can you see the intermediate results of a calculation before the final answer is displayed?

    • A) Evaluate on formula bar
    • B) Shown on formula bar
    • C) Middle of the formula
    • D) Evaluation cannot be done in between the calculation

    Answer: Evaluate on formula bar

    Explanation: The "Evaluate Formula" feature in the formula bar (Formulas > Evaluate Formula) steps through each part of a formula to show intermediate calculation results.