What does the shortcut key Ctrl + Shift + $ do in MS Excel?
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “What does the shortcut key Ctrl + Shift + $ do in MS Excel?”
The accepted answer is B. Apply the Currency number format. Apply the Currency number format is the fact required by What does the shortcut key Ctrl Shift do in MS Excel option B Option A 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 Currency number format Option C Apply the Time number format does not match the stem it is a near-miss used to catch incomplete recall of Apply the Currency number format Remaining alternatives Apply the Percentage number format fall outside the same rule and should be eliminated once Apply the Currency number format is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations MS.
- A. Fill all selected cells with the current entry
Why not A: “Fill all selected cells with the current entry” is not correct. The accepted answer is B. Apply the Currency number format. Apply the Currency number format is the fact required by What does the shortcut key Ctrl Shift do in MS Excel option B Option A Fill all selected cells with the current entry does
- B. Apply the Currency number format ✓
- C. Apply the Time number format
Why not C: “Apply the Time number format” is not correct. The accepted answer is B. Apply the Currency number format. Apply the Currency number format is the fact required by What does the shortcut key Ctrl Shift do in MS Excel option B Option A Fill all selected cells with the current entry does
- D. Apply the Percentage number format
Why not D: “Apply the Percentage number format” is not correct. The accepted answer is B. Apply the Currency number format. Apply the Currency number format is the fact required by What does the shortcut key Ctrl Shift do in MS Excel option B Option A Fill all selected cells with the current entry does
Correct answer
B. Apply the Currency number format
Explanation
Apply the Currency number format is the fact required by What does the shortcut key Ctrl Shift do in MS Excel option B Option A 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 Currency number format Option C Apply the Time number format does not match the stem it is a near-miss used to catch incomplete recall of Apply the Currency number format Remaining alternatives Apply the Percentage number format fall outside the same rule and should be eliminated once Apply the Currency number format is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations MS.
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
- Select the correct shortcut key which is used to copy the formula from the cell above into the active cell in...
- To open the Go To dialog box using the function key shortcut in MS Excel, which key combination should be pres...
- Pressing Ctrl + Shift + ^ in MS Excel will ________.
- Identify the correct shortcut key used to delete the selected cells, rows, or columns in MS Excel.
- What does the shortcut key Ctrl + B do in MS Excel?
- Which shortcut key is used to redo the last undone action in MS Excel?