The keyboard shortcut Ctrl + Shift + 9 in MS Excel performs which of the following actions?
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “The keyboard shortcut Ctrl + Shift + 9 in MS Excel performs which of the following actions?”
The accepted answer is A. Unhide hidden rows within the selection. The keyboard shortcut Ctrl Shift in MS Excel performs which of the following actions is answered by Unhide hidden rows within the selection option A Option B Fill all selected cells with the current entry does not match the stem it is a near-miss used to catch incomplete recall of Unhide hidden rows within the selection Option C Open the Home tab on the ribbon does not match the stem it is a near-miss used to catch incomplete recall of Unhide hidden rows within the selection Remaining alternatives Hide the selected columns 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.
- A. Unhide hidden rows within the selection ✓
- B. Fill all selected cells with the current entry
Why not B: “Fill all selected cells with the current entry” is not correct. The accepted answer is A. Unhide hidden rows within the selection. The keyboard shortcut Ctrl Shift in MS Excel performs which of the following actions is answered by Unhide hidden rows within the selection option A Option B Fill all selected cell
- C. Open the Home tab on the ribbon
Why not C: “Open the Home tab on the ribbon” is not correct. The accepted answer is A. Unhide hidden rows within the selection. The keyboard shortcut Ctrl Shift in MS Excel performs which of the following actions is answered by Unhide hidden rows within the selection option A Option B Fill all selected cell
- D. Hide the selected columns
Why not D: “Hide the selected columns” is not correct. The accepted answer is A. Unhide hidden rows within the selection. The keyboard shortcut Ctrl Shift in MS Excel performs which of the following actions is answered by Unhide hidden rows within the selection option A Option B Fill all selected cell
Correct answer
A. Unhide hidden rows within the selection
Explanation
The keyboard shortcut Ctrl Shift in MS Excel performs which of the following actions is answered by Unhide hidden rows within the selection option A Option B Fill all selected cells with the current entry does not match the stem it is a near-miss used to catch incomplete recall of Unhide hidden rows within the selection Option C Open the Home tab on the ribbon does not match the stem it is a near-miss used to catch incomplete recall of Unhide hidden rows within the selection Remaining alternatives Hide the selected columns 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.
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
- Select the correct shortcut key which is used to undo the last action in MS Excel.
- In MS Excel, which shortcut key helps you open the Find and Replace dialog box?
- Ctrl + B is the shortcut key for which of the following actions in MS Excel?
- What shortcut key combination performs the action to apply bold formatting to selected cells in MS Excel?
- What is the function of Ctrl + Shift + ! in MS Excel?
- The keyboard shortcut Ctrl + Page Down in MS Excel performs which of the following actions?