Identify the correct shortcut key used to apply the Currency number format in MS Excel.
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “Identify the correct shortcut key used to apply the Currency number format in MS Excel.”
The accepted answer is A. Ctrl + Shift + $. “Identify the correct shortcut key used to apply the Currency number format in MS Excel.” is answered by Ctrl + Shift + $ (option A). Option B (“Ctrl + P”) does not match the stem; it is a near-miss used to catch incomplete recall of Ctrl + Shift + $. Option C (“Ctrl + F10”) does not match the stem; it is a near-miss used to catch incomplete recall of Ctrl + Shift + $. Remaining alternatives (Ctrl + Shift + 0) 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, and CSS papers.
- A. Ctrl + Shift + $ ✓
- B. Ctrl + P
Why not B: “Ctrl + P” is not correct. The accepted answer is A. Ctrl + Shift + $. “Identify the correct shortcut key used to apply the Currency number format in MS Excel.” is answered by Ctrl + Shift + $ (option A). Option B (“Ctrl + P”) does not match the stem;
- C. Ctrl + F10
Why not C: “Ctrl + F10” is not correct. The accepted answer is A. Ctrl + Shift + $. “Identify the correct shortcut key used to apply the Currency number format in MS Excel.” is answered by Ctrl + Shift + $ (option A). Option B (“Ctrl + P”) does not match the stem;
- D. Ctrl + Shift + 0
Why not D: “Ctrl + Shift + 0” is not correct. The accepted answer is A. Ctrl + Shift + $. “Identify the correct shortcut key used to apply the Currency number format in MS Excel.” is answered by Ctrl + Shift + $ (option A). Option B (“Ctrl + P”) does not match the stem;
Correct answer
A. Ctrl + Shift + $
Explanation
“Identify the correct shortcut key used to apply the Currency number format in MS Excel.” is answered by Ctrl + Shift + $ (option A). Option B (“Ctrl + P”) does not match the stem; it is a near-miss used to catch incomplete recall of Ctrl + Shift + $. Option C (“Ctrl + F10”) does not match the stem; it is a near-miss used to catch incomplete recall of Ctrl + Shift + $. Remaining alternatives (Ctrl + Shift + 0) 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, and CSS papers.
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
- Pressing Ctrl + O in MS Excel will ________.
- Select the correct shortcut key which is used to open the Insert Function dialog box in MS Excel.
- Identify the correct shortcut key used to open an existing workbook in MS Excel.
- Select the correct shortcut key which is used to apply or remove italic formatting in MS Excel.
- Ctrl + I is the shortcut key for which of the following actions in MS Excel?
- To start a new line within the same cell in MS Excel, which key combination should be pressed?