In MS Excel, the shortcut key Alt + Down Arrow is used to ________.
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys question asks: In MS Excel, the shortcut key Alt + Down Arrow is used to ________. The correct choice is C. Open the AutoFilter drop-down list. 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. Insert the AutoSum formula
Why not A: “Insert the AutoSum formula” does not fit this question. The answer is Open the AutoFilter drop-down list.
- B. Insert the current date into the active cell
Why not B: “Insert the current date into the active cell” does not fit this question. The answer is Open the AutoFilter drop-down list.
- C. Open the AutoFilter drop-down list ✓
- D. Insert new cells, rows, or columns
Why not D: “Insert new cells, rows, or columns” does not fit this question. The answer is Open the AutoFilter drop-down list.
Correct answer
C. Open the AutoFilter drop-down list
Explanation
Open the AutoFilter drop-down list (option C) is the accepted answer to “In MS Excel, the shortcut key Alt + Down Arrow is used to ________.”. Option A (Insert the AutoSum formula) does not fit this question. Option B (Insert the current date into the active cell) does not fit this question. Option D (Insert new cells, rows, or columns) does not fit this question. For this MS Excel Shortcut Keys question, the accepted answer is Open the AutoFilter drop-down list.
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 key combination should be pressed in MS Excel to select the entire row?
- Which shortcut key is used to select the entire column in MS Excel?
- In MS Excel, the shortcut key Ctrl + Shift + Space is used to ________.
- Select the correct shortcut key which is used to print the active worksheet in MS Excel.
- In MS Excel, what is the keyboard shortcut to toggle the display of formulas in cells?
- What shortcut key combination performs the action to insert the AutoSum formula in MS Excel?