What is the function of Ctrl + Shift + 0 in MS Excel?
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “What is the function of Ctrl + Shift + 0 in MS Excel?”
The accepted answer is A. Unhide hidden columns within the selection. Unhide hidden columns within the selection is the fact required by What is the function of Ctrl Shift in MS Excel option A Option B Insert a hyperlink does not match the stem it is a near-miss used to catch incomplete recall of Unhide hidden columns within the selection Option C Create names from row and column labels does not match the stem it is a near-miss used to catch incomplete recall of Unhide hidden columns within the selection Remaining alternatives Calculate all worksheets in all open workbooks fall outside the same rule and should be eliminated once Unhide hidden columns within the selection is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate.
- A. Unhide hidden columns within the selection ✓
- B. Insert a hyperlink
Why not B: “Insert a hyperlink” is not correct. The accepted answer is A. Unhide hidden columns within the selection. Unhide hidden columns within the selection is the fact required by What is the function of Ctrl Shift in MS Excel option A Option B Insert a hyperlink does not match the stem it is
- C. Create names from row and column labels
Why not C: “Create names from row and column labels” is not correct. The accepted answer is A. Unhide hidden columns within the selection. Unhide hidden columns within the selection is the fact required by What is the function of Ctrl Shift in MS Excel option A Option B Insert a hyperlink does not match the stem it is
- D. Calculate all worksheets in all open workbooks
Why not D: “Calculate all worksheets in all open workbooks” is not correct. The accepted answer is A. Unhide hidden columns within the selection. Unhide hidden columns within the selection is the fact required by What is the function of Ctrl Shift in MS Excel option A Option B Insert a hyperlink does not match the stem it is
Correct answer
A. Unhide hidden columns within the selection
Explanation
Unhide hidden columns within the selection is the fact required by What is the function of Ctrl Shift in MS Excel option A Option B Insert a hyperlink does not match the stem it is a near-miss used to catch incomplete recall of Unhide hidden columns within the selection Option C Create names from row and column labels does not match the stem it is a near-miss used to catch incomplete recall of Unhide hidden columns within the selection Remaining alternatives Calculate all worksheets in all open workbooks fall outside the same rule and should be eliminated once Unhide hidden columns within the selection is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate.
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 shortcut key is used to apply the Scientific number format in MS Excel?
- In MS Excel, Alt + F1 is used for which purpose?
- What shortcut key combination performs the action to open the Create Table dialog box in MS Excel?
- Which action is performed when you press Ctrl + ' in MS Excel?
- Identify the correct shortcut key used to unhide hidden rows within the selection in MS Excel.
- Identify the correct shortcut key used to create names from row and column labels in MS Excel.