The keyboard shortcut Ctrl + Shift + # in MS Excel performs which of the following actions?
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys question asks: The keyboard shortcut Ctrl + Shift + # in MS Excel performs which of the following actions? The correct choice is D. Apply the Date number format. 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. Open the Home tab on the ribbon
Why not A: “Open the Home tab on the ribbon” does not fit this question. The answer is Apply the Date number format.
- B. Fill all selected cells with the current entry
Why not B: “Fill all selected cells with the current entry” does not fit this question. The answer is Apply the Date number format.
- C. Toggle the display of formulas in cells
Why not C: “Toggle the display of formulas in cells” does not fit this question. The answer is Apply the Date number format.
- D. Apply the Date number format ✓
Correct answer
D. Apply the Date number format
Explanation
Apply the Date number format (option D) is the accepted answer to “The keyboard shortcut Ctrl + Shift + # in MS Excel performs which of the following actions”. Option A (Open the Home tab on the ribbon) does not fit this question. Option B (Fill all selected cells with the current entry) does not fit this question. Option C (Toggle the display of formulas in cells) does not fit this question. For this MS Excel Shortcut Keys question, the accepted answer is Apply the Date number format.
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 open the Create Table dialog box?
- Pressing Ctrl + I in MS Excel will ________.
- Identify the correct shortcut key used to insert the current date into the active cell in MS Excel.
- What shortcut key combination performs the action to cut the selected cells or data in MS Excel?
- What does the shortcut key Ctrl + 2 do in MS Excel?
- Alt + Enter is the shortcut key for which of the following actions in MS Excel?