In MS Excel, Ctrl + Shift + ~ is used for which purpose?
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “In MS Excel, Ctrl + Shift + ~ is used for which purpose?”
The accepted answer is C. Apply the General number format. In MS Excel Ctrl Shift is used for which purpose is answered by Apply the General number format option C Option A Apply an outline border around selected cells does not match the stem it is a near-miss used to catch incomplete recall of Apply the General number format Option B Apply Flash Fill to the selected column does not match the stem it is a near-miss used to catch incomplete recall of Apply the General number format Remaining alternatives Unhide hidden columns within the selection fall outside the same rule and should be eliminated once Apply the General number format is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations MS Excel.
- A. Apply an outline border around selected cells
Why not A: “Apply an outline border around selected cells” is not correct. The accepted answer is C. Apply the General number format. In MS Excel Ctrl Shift is used for which purpose is answered by Apply the General number format option C Option A Apply an outline border around selected cells does not match the s
- B. Apply Flash Fill to the selected column
Why not B: “Apply Flash Fill to the selected column” is not correct. The accepted answer is C. Apply the General number format. In MS Excel Ctrl Shift is used for which purpose is answered by Apply the General number format option C Option A Apply an outline border around selected cells does not match the s
- C. Apply the General number format ✓
- D. Unhide hidden columns within the selection
Why not D: “Unhide hidden columns within the selection” is not correct. The accepted answer is C. Apply the General number format. In MS Excel Ctrl Shift is used for which purpose is answered by Apply the General number format option C Option A Apply an outline border around selected cells does not match the s
Correct answer
C. Apply the General number format
Explanation
In MS Excel Ctrl Shift is used for which purpose is answered by Apply the General number format option C Option A Apply an outline border around selected cells does not match the stem it is a near-miss used to catch incomplete recall of Apply the General number format Option B Apply Flash Fill to the selected column does not match the stem it is a near-miss used to catch incomplete recall of Apply the General number format Remaining alternatives Unhide hidden columns within the selection fall outside the same rule and should be eliminated once Apply the General number format is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations MS Excel.
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 Ctrl + L in MS Excel performs which of the following actions?
- Which of the following key combinations allows you to insert the AutoSum formula in MS Excel?
- If you want to open the AutoFilter drop-down list in MS Excel, which shortcut key will you use?
- Which of the following key combinations allows you to paste copied or cut content in MS Excel?
- To toggle the display of formulas in cells in MS Excel, which key combination should be pressed?
- Which key combination should be pressed in MS Excel to open the Find dialog box?