Which of the following key combinations allows you to open the AutoFilter drop-down list in MS Excel?
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “Which of the following key combinations allows you to open the AutoFilter drop-down list in MS Excel?”
The accepted answer is D. Alt + Down Arrow. Alt Down Arrow is the person body or term that satisfies Which of the following key combinations allows you to open the AutoFilter drop-down list in MS Excel option D Option A Ctrl Z does not match the stem it is a near-miss used to catch incomplete recall of Alt Down Arrow Option B Ctrl Tab does not match the stem it is a near-miss used to catch incomplete recall of Alt Down Arrow Remaining alternatives F 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.
- A. Ctrl + Z
Why not A: “Ctrl + Z” is not correct. The accepted answer is D. Alt + Down Arrow. Alt Down Arrow is the person body or term that satisfies Which of the following key combinations allows you to open the AutoFilter drop-down list in MS Excel option D Option A Ctrl
- B. Ctrl + Tab
Why not B: “Ctrl + Tab” is not correct. The accepted answer is D. Alt + Down Arrow. Alt Down Arrow is the person body or term that satisfies Which of the following key combinations allows you to open the AutoFilter drop-down list in MS Excel option D Option A Ctrl
- C. F9
Why not C: “F9” is not correct. The accepted answer is D. Alt + Down Arrow. Alt Down Arrow is the person body or term that satisfies Which of the following key combinations allows you to open the AutoFilter drop-down list in MS Excel option D Option A Ctrl
- D. Alt + Down Arrow ✓
Correct answer
D. Alt + Down Arrow
Explanation
Alt Down Arrow is the person body or term that satisfies Which of the following key combinations allows you to open the AutoFilter drop-down list in MS Excel option D Option A Ctrl Z does not match the stem it is a near-miss used to catch incomplete recall of Alt Down Arrow Option B Ctrl Tab does not match the stem it is a near-miss used to catch incomplete recall of Alt Down Arrow Remaining alternatives F 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.
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
- To apply or remove strikethrough formatting in MS Excel, which key combination should be pressed?
- The keyboard shortcut Alt + N in MS Excel performs which of the following actions?
- In MS Excel, what is the keyboard shortcut to apply underline formatting to selected cells?
- Select the correct shortcut key which is used to insert a new worksheet in MS Excel.
- Which shortcut key is used to repeat the last action or toggle a cell reference type in MS Excel?
- Which shortcut key is used to hide the selected rows in MS Excel?