Where can you change automatic or manual calculation mode in Excel?
2019
Where can you change automatic or manual calculation mode in Excel?
Answer: C. Both (A) and (B) — To change the calculation mode in Excel, you can use either of the following methods: 1. Double-click the CAL indicator on the status bar. This toggles…
- A.
Double CAL indicator on status bar
- B.
Go to Tools >> Options >> Calculation and mark the corresponding radio button
- C.
Both (A) and (B)
- D.
None of these
- E.
Only by restarting Excel
Attempted by 517 students.
Show answer & explanation
Correct answer: C
To change the calculation mode in Excel, you can use either of the following methods: 1. Double-click the CAL indicator on the status bar. This toggles between automatic and manual calculation modes directly. 2. Go to Tools >> Options >> Calculation. In the Calculation tab, select the desired mode using the radio buttons. Both methods are valid ways to change the calculation mode in Excel.