In MS Excel, Ctrl + Shift + 9 is used for which purpose?
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “In MS Excel, Ctrl + Shift + 9 is used for which purpose?”
The accepted answer is B. Unhide hidden rows within the selection. In MS Excel Ctrl Shift is used for which purpose is answered by Unhide hidden rows within the selection option B Option A Unhide hidden columns within the selection does not match the stem it is a near-miss used to catch incomplete recall of Unhide hidden rows within the selection Option C Select the entire column does not match the stem it is a near-miss used to catch incomplete recall of Unhide hidden rows within the selection Remaining alternatives Edit the active cell fall outside the same rule and should be eliminated once Unhide hidden rows within the selection is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations MS Excel Shortcut Keys.
- A. Unhide hidden columns within the selection
Why not A: “Unhide hidden columns within the selection” is not correct. The accepted answer is B. Unhide hidden rows within the selection. In MS Excel Ctrl Shift is used for which purpose is answered by Unhide hidden rows within the selection option B Option A Unhide hidden columns within the selection does not match
- B. Unhide hidden rows within the selection ✓
- C. Select the entire column
Why not C: “Select the entire column” is not correct. The accepted answer is B. Unhide hidden rows within the selection. In MS Excel Ctrl Shift is used for which purpose is answered by Unhide hidden rows within the selection option B Option A Unhide hidden columns within the selection does not match
- D. Edit the active cell
Why not D: “Edit the active cell” is not correct. The accepted answer is B. Unhide hidden rows within the selection. In MS Excel Ctrl Shift is used for which purpose is answered by Unhide hidden rows within the selection option B Option A Unhide hidden columns within the selection does not match
Correct answer
B. Unhide hidden rows within the selection
Explanation
In MS Excel Ctrl Shift is used for which purpose is answered by Unhide hidden rows within the selection option B Option A Unhide hidden columns within the selection does not match the stem it is a near-miss used to catch incomplete recall of Unhide hidden rows within the selection Option C Select the entire column does not match the stem it is a near-miss used to catch incomplete recall of Unhide hidden rows within the selection Remaining alternatives Edit the active cell fall outside the same rule and should be eliminated once Unhide hidden rows within the selection is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations MS Excel Shortcut Keys.
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
- Ctrl + 0 is the shortcut key for which of the following actions in MS Excel?
- The keyboard shortcut Ctrl + Shift + % in MS Excel performs which of the following actions?
- Select the correct shortcut key which is used to open the Go To dialog box using the function key shortcut in...
- Which key combination should be pressed in MS Excel to switch between open workbooks?
- In MS Excel, Alt + Enter is used for which purpose?
- Pressing F5 in MS Excel will ________.