Pressing Ctrl + Shift + L in MS Excel will ________.
Difficulty: Medium
About this MCQ
This Medium MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “Pressing Ctrl + Shift + L in MS Excel will ________.”
The accepted answer is B. Toggle AutoFilter on the selected range. Pressing Ctrl Shift L in MS Excel will is answered by Toggle AutoFilter on the selected range option B Option A Open the Insert tab on the ribbon does not match the stem it is a near-miss used to catch incomplete recall of Toggle AutoFilter on the selected range Option C Open the Home tab on the ribbon does not match the stem it is a near-miss used to catch incomplete recall of Toggle AutoFilter on the selected range Remaining alternatives Select the entire worksheet fall outside the same rule and should be eliminated once Toggle AutoFilter on the selected range is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations MS Excel.
- A. Open the Insert tab on the ribbon
Why not A: “Open the Insert tab on the ribbon” is not correct. The accepted answer is B. Toggle AutoFilter on the selected range. Pressing Ctrl Shift L in MS Excel will is answered by Toggle AutoFilter on the selected range option B Option A Open the Insert tab on the ribbon does not match the stem it is a ne
- B. Toggle AutoFilter on the selected range ✓
- C. Open the Home tab on the ribbon
Why not C: “Open the Home tab on the ribbon” is not correct. The accepted answer is B. Toggle AutoFilter on the selected range. Pressing Ctrl Shift L in MS Excel will is answered by Toggle AutoFilter on the selected range option B Option A Open the Insert tab on the ribbon does not match the stem it is a ne
- D. Select the entire worksheet
Why not D: “Select the entire worksheet” is not correct. The accepted answer is B. Toggle AutoFilter on the selected range. Pressing Ctrl Shift L in MS Excel will is answered by Toggle AutoFilter on the selected range option B Option A Open the Insert tab on the ribbon does not match the stem it is a ne
Correct answer
B. Toggle AutoFilter on the selected range
Explanation
Pressing Ctrl Shift L in MS Excel will is answered by Toggle AutoFilter on the selected range option B Option A Open the Insert tab on the ribbon does not match the stem it is a near-miss used to catch incomplete recall of Toggle AutoFilter on the selected range Option C Open the Home tab on the ribbon does not match the stem it is a near-miss used to catch incomplete recall of Toggle AutoFilter on the selected range Remaining alternatives Select the entire worksheet fall outside the same rule and should be eliminated once Toggle AutoFilter on the selected range is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations MS Excel.
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 action is performed when you press Ctrl + O in MS Excel?
- In MS Excel, which shortcut key helps you apply bold formatting to selected cells?
- What does the shortcut key Ctrl + I do in MS Excel?
- If you want to minimize the active workbook window in MS Excel, which shortcut key will you use?
- Which shortcut key is used to unhide hidden rows within the selection in MS Excel?
- If you want to select the entire row in MS Excel, which shortcut key will you use?