What is the function of Ctrl + 0 in MS Excel?
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys question asks: What is the function of Ctrl + 0 in MS Excel? The correct choice is A. Hide the selected columns. Read the options below, commit to one, then use the explanation to see why that choice holds and why the others do not.
MS Excel Shortcut Keys items like this one are written for Pakistan exams such as CSS, FPSC, PPSC, and NTS. The difficulty label is a hint about how much of the topic the stem assumes, not a score. Tags and exam names, when they are present, tell you where else the same idea is tested. Previous and next links stay in MS Excel Shortcut Keys so you can continue the subject. Related questions point at nearby stems if you want another angle on the same idea.
Treat the explanation as part of the question, not a footnote. If you missed it, reread the stem against the correct option before you open the next MS Excel Shortcut Keys item. A timed quiz is the same pool with a clock and a score. A past paper is a full sitting rather than this single question.
- 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” does not fit this question. The answer is Hide the selected columns.
- C. Insert the current date into the active cell
Why not C: “Insert the current date into the active cell” does not fit this question. The answer is Hide the selected columns.
- D. Open the Find and Replace dialog box
Why not D: “Open the Find and Replace dialog box” does not fit this question. The answer is Hide the selected columns.
Correct answer
A. Hide the selected columns
Explanation
Hide the selected columns is the value that answers “What is the function of Ctrl + 0 in MS Excel” (option A). Option B (Start a new line within the same cell) does not fit this question. Option C (Insert the current date into the active cell) does not fit this question. Option D (Open the Find and Replace dialog box) does not fit this question. For this MS Excel Shortcut Keys question, the accepted answer is Hide the selected columns.
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?