If you want to open the AutoFilter drop-down list in MS Excel, which shortcut key will you use?
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “If you want to open the AutoFilter drop-down list in MS Excel, which shortcut key will you use?”
The accepted answer is D. Alt + Down Arrow. If you want to open the AutoFilter drop-down list in MS Excel which shortcut key will you use is answered by Alt Down Arrow option D Option A Ctrl B does not match the stem it is a near-miss used to catch incomplete recall of Alt Down Arrow Option B Ctrl Space does not match the stem it is a near-miss used to catch incomplete recall of Alt Down Arrow Remaining alternatives Ctrl Shift fall outside the same rule and should be eliminated once Alt Down Arrow is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations MS Excel Shortcut Keys recall of this distinction is a regular item in FPSC PPSC NTS.
- A. Ctrl + B
Why not A: “Ctrl + B” is not correct. The accepted answer is D. Alt + Down Arrow. If you want to open the AutoFilter drop-down list in MS Excel which shortcut key will you use is answered by Alt Down Arrow option D Option A Ctrl B does not match the stem it is a
- B. Ctrl + Space
Why not B: “Ctrl + Space” is not correct. The accepted answer is D. Alt + Down Arrow. If you want to open the AutoFilter drop-down list in MS Excel which shortcut key will you use is answered by Alt Down Arrow option D Option A Ctrl B does not match the stem it is a
- C. Ctrl + Shift + &
Why not C: “Ctrl + Shift + &” is not correct. The accepted answer is D. Alt + Down Arrow. If you want to open the AutoFilter drop-down list in MS Excel which shortcut key will you use is answered by Alt Down Arrow option D Option A Ctrl B does not match the stem it is a
- D. Alt + Down Arrow ✓
Correct answer
D. Alt + Down Arrow
Explanation
If you want to open the AutoFilter drop-down list in MS Excel which shortcut key will you use is answered by Alt Down Arrow option D Option A Ctrl B does not match the stem it is a near-miss used to catch incomplete recall of Alt Down Arrow Option B Ctrl Space does not match the stem it is a near-miss used to catch incomplete recall of Alt Down Arrow Remaining alternatives Ctrl Shift fall outside the same rule and should be eliminated once Alt Down Arrow is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations MS Excel Shortcut Keys recall of this distinction is a regular item in FPSC PPSC NTS.
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
- What is the function of Ctrl + O in MS Excel?
- Pressing Ctrl + W in MS Excel will ________.
- Which shortcut key is used to insert the current date into the active cell in MS Excel?
- In MS Excel, Ctrl + Shift + ~ is used for which purpose?
- In MS Excel, what is the keyboard shortcut to insert the AutoSum formula?
- What shortcut key combination performs the action to apply or remove italic formatting in MS Excel?