What is the function of Ctrl + Shift + ! in MS Excel?
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “What is the function of Ctrl + Shift + ! in MS Excel?”
The accepted answer is A. Apply the Number format with two decimal places. Apply the Number format with two decimal places is the fact required by What is the function of Ctrl Shift in MS Excel option A Option B Fill down the content of the cell above 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 Switch between open workbooks 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 Calculate all worksheets in all open workbooks fall outside the same rule and should be eliminated once Apply the Number format with two decimal places is identified MS Excel Shortcut Keys.
- A. Apply the Number format with two decimal places ✓
- B. Fill down the content of the cell above
Why not B: “Fill down the content of the cell above” is not correct. The accepted answer is A. Apply the Number format with two decimal places. Apply the Number format with two decimal places is the fact required by What is the function of Ctrl Shift in MS Excel option A Option B Fill down the content of the cell above doe
- C. Switch between open workbooks
Why not C: “Switch between open workbooks” is not correct. The accepted answer is A. Apply the Number format with two decimal places. Apply the Number format with two decimal places is the fact required by What is the function of Ctrl Shift in MS Excel option A Option B Fill down the content of the cell above doe
- D. Calculate all worksheets in all open workbooks
Why not D: “Calculate all worksheets in all open workbooks” is not correct. The accepted answer is A. Apply the Number format with two decimal places. Apply the Number format with two decimal places is the fact required by What is the function of Ctrl Shift in MS Excel option A Option B Fill down the content of the cell above doe
Correct answer
A. Apply the Number format with two decimal places
Explanation
Apply the Number format with two decimal places is the fact required by What is the function of Ctrl Shift in MS Excel option A Option B Fill down the content of the cell above 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 Switch between open workbooks 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 Calculate all worksheets in all open workbooks fall outside the same rule and should be eliminated once Apply the Number format with two decimal places is identified MS Excel Shortcut Keys.
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 shortcut key is used to fill down the content of the cell above in MS Excel?
- Select the correct shortcut key which is used to undo the last action in MS Excel.
- What does the shortcut key Ctrl + Y do in MS Excel?
- Pressing Ctrl + ` in MS Excel will ________.
- In MS Excel, which shortcut key helps you minimize the active workbook window?
- The keyboard shortcut Ctrl + Shift + 9 in MS Excel performs which of the following actions?