Question

How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
A.F8
B.F9
C.F10
D.F11

Answer 1

How can you update the values of formula cells if Auto Calculate mode of Excel is disabled? A) F8 B) F9 C) F10 D) F11.

Answer 2

Answer:

F9 is used to update the values of formula cells.

Explanation:

F8 mode turns on / off the extent mode.

F9 calculates the workbook. If a cell value is modified then the calculation part associated with the cell gets changed by using this function key

F10 key works similar to the Alt key. It allows us to use the facility in the ribbon without using mouse.

F11  This key is used when the user wants create a chart for the selected range of data.