In MS Excel, the shortcut key Ctrl + Shift + L is used to ________.
Difficulty: Medium
About this MCQ
This Medium MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “In MS Excel, the shortcut key Ctrl + Shift + L is used to ________.”
The accepted answer is D. Toggle AutoFilter on the selected range. In MS Excel the shortcut key Ctrl Shift L is used to is answered by Toggle AutoFilter on the selected range option D Option A Open the Find and Replace dialog box does not match the stem it is a near-miss used to catch incomplete recall of Toggle AutoFilter on the selected range Option B Open the AutoFilter drop-down list does not match the stem it is a near-miss used to catch incomplete recall of Toggle AutoFilter on the selected range Remaining alternatives Open the Find dialog box 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.
- A. Open the Find and Replace dialog box
Why not A: “Open the Find and Replace dialog box” is not correct. The accepted answer is D. Toggle AutoFilter on the selected range. In MS Excel the shortcut key Ctrl Shift L is used to is answered by Toggle AutoFilter on the selected range option D Option A Open the Find and Replace dialog box does not match th
- B. Open the AutoFilter drop-down list
Why not B: “Open the AutoFilter drop-down list” is not correct. The accepted answer is D. Toggle AutoFilter on the selected range. In MS Excel the shortcut key Ctrl Shift L is used to is answered by Toggle AutoFilter on the selected range option D Option A Open the Find and Replace dialog box does not match th
- C. Open the Find dialog box
Why not C: “Open the Find dialog box” is not correct. The accepted answer is D. Toggle AutoFilter on the selected range. In MS Excel the shortcut key Ctrl Shift L is used to is answered by Toggle AutoFilter on the selected range option D Option A Open the Find and Replace dialog box does not match th
- D. Toggle AutoFilter on the selected range ✓
Correct answer
D. Toggle AutoFilter on the selected range
Explanation
In MS Excel the shortcut key Ctrl Shift L is used to is answered by Toggle AutoFilter on the selected range option D Option A Open the Find and Replace dialog box does not match the stem it is a near-miss used to catch incomplete recall of Toggle AutoFilter on the selected range Option B Open the AutoFilter drop-down list does not match the stem it is a near-miss used to catch incomplete recall of Toggle AutoFilter on the selected range Remaining alternatives Open the Find dialog box 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.
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 Shift + F11 in MS Excel?
- The keyboard shortcut Alt + F1 in MS Excel performs which of the following actions?
- What does the shortcut key Ctrl + E do in MS Excel?
- If you want to apply or remove underline formatting in MS Excel, which shortcut key will you use?
- Which shortcut key is used to select the entire row in MS Excel?
- Select the correct shortcut key which is used to apply the Number format with two decimal places in MS Excel.