What is the function of Ctrl + Shift + & in MS Excel?
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys question asks: What is the function of Ctrl + Shift + & in MS Excel? The correct choice is D. Apply an outline border around selected cells. Read the options below, commit to one, then use the explanation to see why that choice holds and why the others do not.
MS Excel Shortcut Keys items like this one are written for Pakistan exams such as CSS, FPSC, PPSC, and NTS. The difficulty label is a hint about how much of the topic the stem assumes, not a score. Tags and exam names, when they are present, tell you where else the same idea is tested. Previous and next links stay in MS Excel Shortcut Keys so you can continue the subject. Related questions point at nearby stems if you want another angle on the same idea.
Treat the explanation as part of the question, not a footnote. If you missed it, reread the stem against the correct option before you open the next MS Excel Shortcut Keys item. A timed quiz is the same pool with a clock and a score. A past paper is a full sitting rather than this single question.
- A. Apply the Time number format
Why not A: “Apply the Time number format” does not fit this question. The answer is Apply an outline border around selected cells.
- B. Select the entire row
Why not B: “Select the entire row” does not fit this question. The answer is Apply an outline border around selected cells.
- C. Undo the last action
Why not C: “Undo the last action” does not fit this question. The answer is Apply an outline border around selected cells.
- 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 value that answers “What is the function of Ctrl + Shift + & in MS Excel” (option D). Option A (Apply the Time number format) does not fit this question. Option B (Select the entire row) does not fit this question. Option C (Undo the last action) does not fit this question. For this MS Excel Shortcut Keys question, the accepted answer is Apply an outline border around selected cells.
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?