Select the correct shortcut key which is used to apply the Number format with two decimal places in MS Excel.
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “Select the correct shortcut key which is used to apply the Number format with two decimal places in MS Excel.”
The accepted answer is A. Ctrl + Shift + !. Select the correct shortcut key which is used to apply the Number format with two decimal places in MS Excel is answered by Ctrl Shift option A Option B Alt Down Arrow does not match the stem it is a near-miss used to catch incomplete recall of Ctrl Shift Option C Ctrl Page Down does not match the stem it is a near-miss used to catch incomplete recall of Ctrl Shift Remaining alternatives Ctrl A fall outside the same rule and should be eliminated once Ctrl Shift is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations MS Excel Shortcut Keys recall of this distinction is a regular item in FPSC PPSC NTS.
- A. Ctrl + Shift + ! ✓
- B. Alt + Down Arrow
Why not B: “Alt + Down Arrow” is not correct. The accepted answer is A. Ctrl + Shift + !. Select the correct shortcut key which is used to apply the Number format with two decimal places in MS Excel is answered by Ctrl Shift option A Option B Alt Down Arrow does not mat
- C. Ctrl + Page Down
Why not C: “Ctrl + Page Down” is not correct. The accepted answer is A. Ctrl + Shift + !. Select the correct shortcut key which is used to apply the Number format with two decimal places in MS Excel is answered by Ctrl Shift option A Option B Alt Down Arrow does not mat
- D. Ctrl + A
Why not D: “Ctrl + A” is not correct. The accepted answer is A. Ctrl + Shift + !. Select the correct shortcut key which is used to apply the Number format with two decimal places in MS Excel is answered by Ctrl Shift option A Option B Alt Down Arrow does not mat
Correct answer
A. Ctrl + Shift + !
Explanation
Select the correct shortcut key which is used to apply the Number format with two decimal places in MS Excel is answered by Ctrl Shift option A Option B Alt Down Arrow does not match the stem it is a near-miss used to catch incomplete recall of Ctrl Shift Option C Ctrl Page Down does not match the stem it is a near-miss used to catch incomplete recall of Ctrl Shift Remaining alternatives Ctrl A fall outside the same rule and should be eliminated once Ctrl Shift is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations MS Excel Shortcut Keys recall of this distinction is a regular item in FPSC PPSC NTS.
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
- The keyboard shortcut Alt + F1 in MS Excel performs which of the following actions?
- In MS Excel, Alt + Enter is used for which purpose?
- Pressing F9 in MS Excel will ________.
- Select the correct shortcut key which is used to open the Go To dialog box using the function key shortcut in...
- In MS Excel, the shortcut key Ctrl + Shift + L is used to ________.
- Ctrl + 0 is the shortcut key for which of the following actions in MS Excel?