In MS Excel, Ctrl + Shift + L is used for which purpose?
Difficulty: Medium
About this MCQ
This Medium MS Excel Shortcut Keys question asks: In MS Excel, Ctrl + Shift + L is used for which purpose? The correct choice is B. Toggle AutoFilter on the selected range. 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. Start a new line within the same cell
Why not A: “Start a new line within the same cell” does not fit this question. The answer is Toggle AutoFilter on the selected range.
- B. Toggle AutoFilter on the selected range ✓
- C. Cut the selected cells or data
Why not C: “Cut the selected cells or data” does not fit this question. The answer is Toggle AutoFilter on the selected range.
- D. Create a chart of the selected data in a new sheet
Why not D: “Create a chart of the selected data in a new sheet” does not fit this question. The answer is Toggle AutoFilter on the selected range.
Correct answer
B. Toggle AutoFilter on the selected range
Explanation
Toggle AutoFilter on the selected range (option B) is the accepted answer to “In MS Excel, Ctrl + Shift + L is used for which purpose”. Option A (Start a new line within the same cell) does not fit this question. Option C (Cut the selected cells or data) does not fit this question. Option D (Create a chart of the selected data in a new sheet) does not fit this question. For this MS Excel Shortcut Keys question, the accepted answer is Toggle AutoFilter on the selected range.
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
- If you want to select the entire worksheet in MS Excel, which shortcut key will you use?
- The keyboard shortcut Ctrl + F1 in MS Excel performs which of the following actions?
- In MS Excel, the shortcut key Ctrl + 0 is used to ________.
- What is the function of F2 in MS Excel?
- Which action is performed when you press Ctrl + Page Down in MS Excel?
- In MS Excel, the shortcut key Ctrl + Shift + _ is used to ________.