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 MCQ checks one syllabus fact.
The question is: “The keyboard shortcut Ctrl + Shift + # in MS Excel performs which of the following actions?”
The accepted answer is D. Apply the Date number format. The keyboard shortcut Ctrl Shift in MS Excel performs which of the following actions is answered by Apply the Date number format option D Option A Open the Home tab on the ribbon does not match the stem it is a near-miss used to catch incomplete recall of Apply the Date number format Option B Fill all selected cells with the current entry does not match the stem it is a near-miss used to catch incomplete recall of Apply the Date number format Remaining alternatives Toggle the display of formulas in cells fall outside the same rule and should be eliminated once Apply the Date number format is identified MS Excel Shortcut Keys questions of this type reward precise definitions.
- A. Open the Home tab on the ribbon
Why not A: “Open the Home tab on the ribbon” is not correct. The accepted answer is D. Apply the Date number format. The keyboard shortcut Ctrl Shift in MS Excel performs which of the following actions is answered by Apply the Date number format option D Option A Open the Home tab on the ribbon d
- B. Fill all selected cells with the current entry
Why not B: “Fill all selected cells with the current entry” is not correct. The accepted answer is D. Apply the Date number format. The keyboard shortcut Ctrl Shift in MS Excel performs which of the following actions is answered by Apply the Date number format option D Option A Open the Home tab on the ribbon d
- C. Toggle the display of formulas in cells
Why not C: “Toggle the display of formulas in cells” is not correct. The accepted answer is D. Apply the Date number format. The keyboard shortcut Ctrl Shift in MS Excel performs which of the following actions is answered by Apply the Date number format option D Option A Open the Home tab on the ribbon d
- D. Apply the Date number format ✓
Correct answer
D. Apply the Date number format
Explanation
The keyboard shortcut Ctrl Shift in MS Excel performs which of the following actions is answered by Apply the Date number format option D Option A Open the Home tab on the ribbon does not match the stem it is a near-miss used to catch incomplete recall of Apply the Date number format Option B Fill all selected cells with the current entry does not match the stem it is a near-miss used to catch incomplete recall of Apply the Date number format Remaining alternatives Toggle the display of formulas in cells fall outside the same rule and should be eliminated once Apply the Date number format 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 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?