Select the correct shortcut key which is used to toggle AutoFilter on the selected range in MS Excel.
Difficulty: Medium
About this MCQ
This Medium MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “Select the correct shortcut key which is used to toggle AutoFilter on the selected range in MS Excel.”
The accepted answer is C. Ctrl + Shift + L. Ctrl + Shift + L is the correct shortcut key used to toggle AutoFilter on the selected range in MS Excel.
- A. Ctrl + W
Why not A: “Ctrl + W” is not correct. The accepted answer is C. Ctrl + Shift + L. Ctrl + Shift + L is the correct shortcut key used to toggle AutoFilter on the selected range in MS Excel.
- B. Ctrl + N
Why not B: “Ctrl + N” is not correct. The accepted answer is C. Ctrl + Shift + L. Ctrl + Shift + L is the correct shortcut key used to toggle AutoFilter on the selected range in MS Excel.
- C. Ctrl + Shift + L ✓
- D. Ctrl + Y
Why not D: “Ctrl + Y” is not correct. The accepted answer is C. Ctrl + Shift + L. Ctrl + Shift + L is the correct shortcut key used to toggle AutoFilter on the selected range in MS Excel.
Correct answer
C. Ctrl + Shift + L
Explanation
Ctrl + Shift + L is the correct shortcut key used to toggle AutoFilter on the selected range in 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
- Select the correct shortcut key which is used to select the entire row in MS Excel.
- What shortcut key combination performs the action to undo the last action in MS Excel?
- The keyboard shortcut Ctrl + 4 in MS Excel performs which of the following actions?
- Which key combination should be pressed in MS Excel to start the spelling check?
- In MS Excel, F4 is used for which purpose?
- What shortcut key combination performs the action to open the Print Preview window in MS Excel?