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 D. Apply the Number format with two decimal places. In MS Excel Ctrl Shift is used for which purpose is answered by Apply the Number format with two decimal places option D Option A 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 Number format with two decimal places Option B Insert the current date into the active cell 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 Create a chart of the selected data in a new sheet fall outside the same rule and should be eliminated once Apply the Number format with two decimal places is.
- A. Apply Flash Fill to the selected column
Why not A: “Apply Flash Fill to the selected column” is not correct. The accepted answer is D. Apply the Number format with two decimal places. In MS Excel Ctrl Shift is used for which purpose is answered by Apply the Number format with two decimal places option D Option A Apply Flash Fill to the selected column does not m
- B. Insert the current date into the active cell
Why not B: “Insert the current date into the active cell” is not correct. The accepted answer is D. Apply the Number format with two decimal places. In MS Excel Ctrl Shift is used for which purpose is answered by Apply the Number format with two decimal places option D Option A Apply Flash Fill to the selected column does not m
- C. Create a chart of the selected data in a new sheet
Why not C: “Create a chart of the selected data in a new sheet” is not correct. The accepted answer is D. Apply the Number format with two decimal places. In MS Excel Ctrl Shift is used for which purpose is answered by Apply the Number format with two decimal places option D Option A Apply Flash Fill to the selected column does not m
- D. Apply the Number format with two decimal places ✓
Correct answer
D. Apply the Number format with two decimal places
Explanation
In MS Excel Ctrl Shift is used for which purpose is answered by Apply the Number format with two decimal places option D Option A 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 Number format with two decimal places Option B Insert the current date into the active cell 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 Create a chart of the selected data in a new sheet fall outside the same rule and should be eliminated once Apply the Number format with two decimal places is.
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
- Identify the correct shortcut key used to insert the current date into the active cell in MS Excel.
- Identify the correct shortcut key used to apply or remove underline formatting in MS Excel.
- What does the shortcut key Ctrl + 2 do in MS Excel?
- Pressing Ctrl + I in MS Excel will ________.
- Which key combination should be pressed in MS Excel to apply the Percentage number format?
- What shortcut key combination performs the action to cut the selected cells or data in MS Excel?