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 D. Apply an outline border around selected cells. Apply an outline border around selected cells is the fact required by What is the function of Ctrl Shift in MS Excel option D Option A Apply the Time number format does not match the stem it is a near-miss used to catch incomplete recall of Apply an outline border around selected cells Option B Select the entire row does not match the stem it is a near-miss used to catch incomplete recall of Apply an outline border around selected cells Remaining alternatives Undo the last action fall outside the same rule and should be eliminated once Apply an outline border around selected cells is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate.
- A. Apply the Time number format
Why not A: “Apply the Time number format” is not correct. The accepted answer is D. Apply an outline border around selected cells. Apply an outline border around selected cells is the fact required by What is the function of Ctrl Shift in MS Excel option D Option A Apply the Time number format does not match t
- B. Select the entire row
Why not B: “Select the entire row” is not correct. The accepted answer is D. Apply an outline border around selected cells. Apply an outline border around selected cells is the fact required by What is the function of Ctrl Shift in MS Excel option D Option A Apply the Time number format does not match t
- C. Undo the last action
Why not C: “Undo the last action” is not correct. The accepted answer is D. Apply an outline border around selected cells. Apply an outline border around selected cells is the fact required by What is the function of Ctrl Shift in MS Excel option D Option A Apply the Time number format does not match t
- D. Apply an outline border around selected cells ✓
Correct answer
D. Apply an outline border around selected cells
Explanation
Apply an outline border around selected cells is the fact required by What is the function of Ctrl Shift in MS Excel option D Option A Apply the Time number format does not match the stem it is a near-miss used to catch incomplete recall of Apply an outline border around selected cells Option B Select the entire row does not match the stem it is a near-miss used to catch incomplete recall of Apply an outline border around selected cells Remaining alternatives Undo the last action fall outside the same rule and should be eliminated once Apply an outline border around selected cells is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate.
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
- What shortcut key combination performs the action to open the Print Preview window in MS Excel?
- What shortcut key combination performs the action to create names from row and column labels in MS Excel?
- In MS Excel, F4 is used for which purpose?
- Which key combination should be pressed in MS Excel to insert a new worksheet?
- Select the correct shortcut key which is used to toggle AutoFilter on the selected range in MS Excel.
- In MS Excel, which shortcut key helps you select the entire column?