In MS Excel, what is the keyboard shortcut to calculate all worksheets in all open workbooks?
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “In MS Excel, what is the keyboard shortcut to calculate all worksheets in all open workbooks?”
The accepted answer is B. F9. “In MS Excel, what is the keyboard shortcut to calculate all worksheets in all open workbooks” is answered by F9 (option B). Option A (“Ctrl + Tab”) does not match the stem; it is a near-miss used to catch incomplete recall of F9. Option C (“F2”) does not match the stem; it is a near-miss used to catch incomplete recall of F9. Remaining alternatives (Ctrl + 2) fall outside the same rule and should be eliminated once F9 is identified. MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations. MS Excel Shortcut Keys recall of this distinction is a regular item in FPSC, PPSC, NTS, and CSS papers.
- A. Ctrl + Tab
Why not A: “Ctrl + Tab” is not correct. The accepted answer is B. F9. “In MS Excel, what is the keyboard shortcut to calculate all worksheets in all open workbooks” is answered by F9 (option B). Option A (“Ctrl + Tab”) does not match the stem; it is
- B. F9 ✓
- C. F2
Why not C: “F2” is not correct. The accepted answer is B. F9. “In MS Excel, what is the keyboard shortcut to calculate all worksheets in all open workbooks” is answered by F9 (option B). Option A (“Ctrl + Tab”) does not match the stem; it is
- D. Ctrl + 2
Why not D: “Ctrl + 2” is not correct. The accepted answer is B. F9. “In MS Excel, what is the keyboard shortcut to calculate all worksheets in all open workbooks” is answered by F9 (option B). Option A (“Ctrl + Tab”) does not match the stem; it is
Correct answer
B. F9
Explanation
“In MS Excel, what is the keyboard shortcut to calculate all worksheets in all open workbooks” is answered by F9 (option B). Option A (“Ctrl + Tab”) does not match the stem; it is a near-miss used to catch incomplete recall of F9. Option C (“F2”) does not match the stem; it is a near-miss used to catch incomplete recall of F9. Remaining alternatives (Ctrl + 2) fall outside the same rule and should be eliminated once F9 is identified. MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations. MS Excel Shortcut Keys recall of this distinction is a regular item in FPSC, PPSC, NTS, and CSS papers.
Source: MS Excel Official Shortcut Key Reference Guide
Tags: Shortcut Keys, Computer MCQs, MS Office, MS Excel, Keyboard Shortcuts
Submitted by: MCQsHub Editorial
Related MCQs
- Which key combination should be pressed in MS Excel to select the entire column?
- What is the function of Ctrl + F1 in MS Excel?
- To select the entire worksheet or current data region in MS Excel, which key combination should be pressed?
- Which shortcut key is used to unhide hidden columns within the selection in MS Excel?
- In MS Excel, Ctrl + ; is used for which purpose?
- The keyboard shortcut Ctrl + Shift + ^ in MS Excel performs which of the following actions?