Challenger App

No.1 PSC Learning App

★
★
★
★
★
1M+ Downloads
_____ key can be used to update formulas in an Excel Sheet when Auto Calculate mode is disabled.

AF8

BF9

CF10

DF11

Answer:

B. F9

Read Explanation:

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.


Related Questions:

Which one is not used as spreadsheet software?
The intersection of a row and a column in Excel is called:
Which symbol is always used to begin a formula in Excel?
What is the primary purpose of Pivot Table in Excel?
Which function is used to calculate the "sum of a range of cells"?