Question

_____ key can be used to update formulas in an Excel Sheet when Auto Calculate mode is disabled.

• A. F8
• B. F9
• C. F10
• D. F11

Answer 1

Answer:

B. F9

F9. F9 Key: When Excel is set to Manual Calculation mode (Auto Calculate disabled), pressing F9 recalculates and updates all formulas across all open workbooks. Shift + F9: Updates formulas only in the currently active worksheet. Ctrl + Alt + F9: Forces a full recalculation of all formulas in all open workbooks, even if they haven't changed.