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 Time number format. Apply the Time number format is the fact required by What is the function of Ctrl Shift in MS Excel option A Option B Apply the Number format with two decimal places does not match the stem it is a near-miss used to catch incomplete recall of Apply the Time number format Option C Create a chart of the selected data in a new sheet does not match the stem it is a near-miss used to catch incomplete recall of Apply the Time number format Remaining alternatives Unhide hidden columns within the selection fall outside the same rule and should be eliminated once Apply the Time number format is identified MS Excel Shortcut Keys questions of this type reward precise.
- A. Apply the Time number format ✓
- B. Apply the Number format with two decimal places
Why not B: “Apply the Number format with two decimal places” is not correct. The accepted answer is A. Apply the Time number format. Apply the Time number format is the fact required by What is the function of Ctrl Shift in MS Excel option A Option B Apply the Number format with two decimal places does not match
- 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 A. Apply the Time number format. Apply the Time number format is the fact required by What is the function of Ctrl Shift in MS Excel option A Option B Apply the Number format with two decimal places does not match
- D. Unhide hidden columns within the selection
Why not D: “Unhide hidden columns within the selection” is not correct. The accepted answer is A. Apply the Time number format. Apply the Time number format is the fact required by What is the function of Ctrl Shift in MS Excel option A Option B Apply the Number format with two decimal places does not match
Correct answer
A. Apply the Time number format
Explanation
Apply the Time number format is the fact required by What is the function of Ctrl Shift in MS Excel option A Option B Apply the Number format with two decimal places does not match the stem it is a near-miss used to catch incomplete recall of Apply the Time number format Option C Create a chart of the selected data in a new sheet does not match the stem it is a near-miss used to catch incomplete recall of Apply the Time number format Remaining alternatives Unhide hidden columns within the selection fall outside the same rule and should be eliminated once Apply the Time number format is identified MS Excel Shortcut Keys questions of this type reward precise.
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
- In MS Excel, Ctrl + 9 is used for which purpose?
- What shortcut key combination performs the action to create an embedded chart of the selected data in MS Excel...
- Which action is performed when you press Ctrl + Shift + Space in MS Excel?
- Which of the following key combinations allows you to open the Home tab on the ribbon in MS Excel?
- To move to the previous worksheet in the workbook in MS Excel, which key combination should be pressed?
- Which of the following key combinations allows you to apply an outline border around selected cells in MS Exce...