In MS Excel, the shortcut key Ctrl + Shift + 9 is used to ________.
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “In MS Excel, the shortcut key Ctrl + Shift + 9 is used to ________.”
The accepted answer is B. Unhide hidden rows within the selection. In MS Excel the shortcut key Ctrl Shift is used to is answered by Unhide hidden rows within the selection option B Option A Calculate all worksheets in all open workbooks does not match the stem it is a near-miss used to catch incomplete recall of Unhide hidden rows within the selection Option C Close the active workbook does not match the stem it is a near-miss used to catch incomplete recall of Unhide hidden rows within the selection Remaining alternatives Repeat the last action or toggle a cell reference type 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.
- A. Calculate all worksheets in all open workbooks
Why not A: “Calculate all worksheets in all open workbooks” is not correct. The accepted answer is B. Unhide hidden rows within the selection. In MS Excel the shortcut key Ctrl Shift is used to is answered by Unhide hidden rows within the selection option B Option A Calculate all worksheets in all open workbooks does not
- B. Unhide hidden rows within the selection ✓
- C. Close the active workbook
Why not C: “Close the active workbook” is not correct. The accepted answer is B. Unhide hidden rows within the selection. In MS Excel the shortcut key Ctrl Shift is used to is answered by Unhide hidden rows within the selection option B Option A Calculate all worksheets in all open workbooks does not
- D. Repeat the last action or toggle a cell reference type
Why not D: “Repeat the last action or toggle a cell reference type” is not correct. The accepted answer is B. Unhide hidden rows within the selection. In MS Excel the shortcut key Ctrl Shift is used to is answered by Unhide hidden rows within the selection option B Option A Calculate all worksheets in all open workbooks does not
Correct answer
B. Unhide hidden rows within the selection
Explanation
In MS Excel the shortcut key Ctrl Shift is used to is answered by Unhide hidden rows within the selection option B Option A Calculate all worksheets in all open workbooks does not match the stem it is a near-miss used to catch incomplete recall of Unhide hidden rows within the selection Option C Close the active workbook does not match the stem it is a near-miss used to catch incomplete recall of Unhide hidden rows within the selection Remaining alternatives Repeat the last action or toggle a cell reference type 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.
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
- In MS Excel, which shortcut key helps you apply or remove bold formatting?
- If you want to insert a new worksheet in MS Excel, which shortcut key will you use?
- In MS Excel, which shortcut key helps you insert the AutoSum formula?
- What is the function of Alt + Down Arrow in MS Excel?
- Identify the correct shortcut key used to copy the selected cells or data in MS Excel.
- The keyboard shortcut Ctrl + I in MS Excel performs which of the following actions?