How can you update the values of formula cells if Auto Calculate mode of Excel…
2019
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
Answer: B. F9 — When Auto Calculate mode is disabled in Excel, formula cells do not update automatically. To manually update the values of formula cells, press the F9 key.…
- A.
F8
- B.
F9
- C.
F10
- D.
F11
- E.
None of these
Attempted by 544 students.
Show answer & explanation
Correct answer: B
When Auto Calculate mode is disabled in Excel, formula cells do not update automatically. To manually update the values of formula cells, press the F9 key. This recalculates all formulas in the workbook.
Loading lesson…