Identify the correct shortcut key used to calculate all worksheets in all open workbooks in MS Excel.
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “Identify the correct shortcut key used to calculate all worksheets in all open workbooks in MS Excel.”
The accepted answer is A. F9. “Identify the correct shortcut key used to calculate all worksheets in all open workbooks in MS Excel.” is answered by F9 (option A). Option B (“Ctrl + Page Down”) does not match the stem; it is a near-miss used to catch incomplete recall of F9. Option C (“F11”) does not match the stem; it is a near-miss used to catch incomplete recall of F9. Remaining alternatives (F2) 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. F9 ✓
- B. Ctrl + Page Down
Why not B: “Ctrl + Page Down” is not correct. The accepted answer is A. F9. “Identify the correct shortcut key used to calculate all worksheets in all open workbooks in MS Excel.” is answered by F9 (option A). Option B (“Ctrl + Page Down”) does not match t
- C. F11
Why not C: “F11” is not correct. The accepted answer is A. F9. “Identify the correct shortcut key used to calculate all worksheets in all open workbooks in MS Excel.” is answered by F9 (option A). Option B (“Ctrl + Page Down”) does not match t
- D. F2
Why not D: “F2” is not correct. The accepted answer is A. F9. “Identify the correct shortcut key used to calculate all worksheets in all open workbooks in MS Excel.” is answered by F9 (option A). Option B (“Ctrl + Page Down”) does not match t
Correct answer
A. F9
Explanation
“Identify the correct shortcut key used to calculate all worksheets in all open workbooks in MS Excel.” is answered by F9 (option A). Option B (“Ctrl + Page Down”) does not match the stem; it is a near-miss used to catch incomplete recall of F9. Option C (“F11”) does not match the stem; it is a near-miss used to catch incomplete recall of F9. Remaining alternatives (F2) 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
- What is the function of Ctrl + 0 in MS Excel?
- If you want to hide the selected rows in MS Excel, which shortcut key will you use?
- What does the shortcut key Ctrl + Shift + @ do in MS Excel?
- In MS Excel, what is the keyboard shortcut to minimize the active workbook window?
- Which shortcut key is used to apply the General number format in MS Excel?
- In MS Excel, the shortcut key Ctrl + Minus is used to ________.