What is the function of Ctrl + 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 + 0 in MS Excel?”
The accepted answer is A. Hide the selected columns. Hide the selected columns is the fact required by What is the function of Ctrl in MS Excel option A Option B Start a new line within the same cell does not match the stem it is a near-miss used to catch incomplete recall of Hide the selected columns Option C Insert the current date into the active cell does not match the stem it is a near-miss used to catch incomplete recall of Hide the selected columns Remaining alternatives Open the Find and Replace dialog box fall outside the same rule and should be eliminated once Hide the selected columns is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations MS Excel.
- A. Hide the selected columns ✓
- B. Start a new line within the same cell
Why not B: “Start a new line within the same cell” is not correct. The accepted answer is A. Hide the selected columns. Hide the selected columns is the fact required by What is the function of Ctrl in MS Excel option A Option B Start a new line within the same cell does not match the stem it is a n
- C. Insert the current date into the active cell
Why not C: “Insert the current date into the active cell” is not correct. The accepted answer is A. Hide the selected columns. Hide the selected columns is the fact required by What is the function of Ctrl in MS Excel option A Option B Start a new line within the same cell does not match the stem it is a n
- D. Open the Find and Replace dialog box
Why not D: “Open the Find and Replace dialog box” is not correct. The accepted answer is A. Hide the selected columns. Hide the selected columns is the fact required by What is the function of Ctrl in MS Excel option A Option B Start a new line within the same cell does not match the stem it is a n
Correct answer
A. Hide the selected columns
Explanation
Hide the selected columns is the fact required by What is the function of Ctrl in MS Excel option A Option B Start a new line within the same cell does not match the stem it is a near-miss used to catch incomplete recall of Hide the selected columns Option C Insert the current date into the active cell does not match the stem it is a near-miss used to catch incomplete recall of Hide the selected columns Remaining alternatives Open the Find and Replace dialog box fall outside the same rule and should be eliminated once Hide the selected columns is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations MS Excel.
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 General number format in MS Excel?
- Identify the correct shortcut key used to calculate all worksheets in all open workbooks in MS Excel.
- In MS Excel, the shortcut key Ctrl + X is used to ________.
- Which shortcut key is used to start the spelling check in MS Excel?
- Which shortcut key is used to create a chart of the selected data in a new sheet in MS Excel?
- If you want to hide the selected rows in MS Excel, which shortcut key will you use?