In MS Excel, what is the keyboard shortcut to open the AutoFilter drop-down list?
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys question asks: In MS Excel, what is the keyboard shortcut to open the AutoFilter drop-down list? The correct choice is D. Alt + Down Arrow. 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. Ctrl + B
Why not A: “Ctrl + B” does not fit this question. The answer is Alt + Down Arrow.
- B. Ctrl + F10
Why not B: “Ctrl + F10” does not fit this question. The answer is Alt + Down Arrow.
- C. Ctrl + Shift + &
Why not C: “Ctrl + Shift + &” does not fit this question. The answer is Alt + Down Arrow.
- D. Alt + Down Arrow ✓
Correct answer
D. Alt + Down Arrow
Explanation
Alt + Down Arrow (option D) is the accepted answer to “In MS Excel, what is the keyboard shortcut to open the AutoFilter drop-down list”. Option A (Ctrl + B) does not fit this question. Option B (Ctrl + F10) does not fit this question. Option C (Ctrl + Shift + &) does not fit this question. For this MS Excel Shortcut Keys question, the accepted answer is Alt + Down Arrow.
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
- In MS Excel, what is the keyboard shortcut to delete the selected cells, rows, or columns?
- Which key combination should be pressed in MS Excel to apply italic formatting to selected cells?
- Which shortcut key is used to open the Home tab on the ribbon in MS Excel?
- In MS Excel, the shortcut key Ctrl + Shift + % is used to ________.
- What is the function of Ctrl + Z in MS Excel?
- Identify the correct shortcut key used to open the Go To dialog box in MS Excel.