In MS Excel, the shortcut key Ctrl + Shift + ! is used to ________.
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “In MS Excel, the shortcut key Ctrl + Shift + ! is used to ________.”
The accepted answer is B. Apply the Number format with two decimal places. In MS Excel the shortcut key Ctrl Shift is used to is answered by Apply the Number format with two decimal places option B Option A Apply or remove bold formatting does not match the stem it is a near-miss used to catch incomplete recall of Apply the Number format with two decimal places Option C Unhide hidden rows within the selection does not match the stem it is a near-miss used to catch incomplete recall of Apply the Number format with two decimal places Remaining alternatives Open the Insert Function dialog box fall outside the same rule and should be eliminated once Apply the Number format with two decimal places is identified MS Excel Shortcut Keys questions of this.
- A. Apply or remove bold formatting
Why not A: “Apply or remove bold formatting” is not correct. The accepted answer is B. Apply the Number format with two decimal places. In MS Excel the shortcut key Ctrl Shift is used to is answered by Apply the Number format with two decimal places option B Option A Apply or remove bold formatting does not match t
- B. Apply the Number format with two decimal places ✓
- C. Unhide hidden rows within the selection
Why not C: “Unhide hidden rows within the selection” is not correct. The accepted answer is B. Apply the Number format with two decimal places. In MS Excel the shortcut key Ctrl Shift is used to is answered by Apply the Number format with two decimal places option B Option A Apply or remove bold formatting does not match t
- D. Open the Insert Function dialog box
Why not D: “Open the Insert Function dialog box” is not correct. The accepted answer is B. Apply the Number format with two decimal places. In MS Excel the shortcut key Ctrl Shift is used to is answered by Apply the Number format with two decimal places option B Option A Apply or remove bold formatting does not match t
Correct answer
B. Apply the Number format with two decimal places
Explanation
In MS Excel the shortcut key Ctrl Shift is used to is answered by Apply the Number format with two decimal places option B Option A Apply or remove bold formatting does not match the stem it is a near-miss used to catch incomplete recall of Apply the Number format with two decimal places Option C Unhide hidden rows within the selection does not match the stem it is a near-miss used to catch incomplete recall of Apply the Number format with two decimal places Remaining alternatives Open the Insert Function dialog box fall outside the same rule and should be eliminated once Apply the Number format with two decimal places is identified MS Excel Shortcut Keys questions of this.
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
- Which of the following key combinations allows you to open the Format Cells dialog box in MS Excel?
- Select the correct shortcut key which is used to open the Insert tab on the ribbon in MS Excel.
- In MS Excel, F11 is used for which purpose?
- Which shortcut key is used to copy the formula from the cell above into the active cell in MS Excel?
- In MS Excel, what is the keyboard shortcut to cut the selected cells or data?
- Pressing Ctrl + Shift + F3 in MS Excel will ________.