Correct Answer:
A. Shift + Down Arrow
In Microsoft Excel, extending a selection involves using the Shift key in combination with arrow keys. This allows users to quickly select a range of cells.
- Shift + Down Arrow is the correct shortcut to extend the current selection downwards by one cell. Holding Shift while pressing an arrow key extends the selection in that direction.
- Ctrl + Shift + Right Arrow extends the selection to the last non-empty cell to the right.
- Alt + Down Arrow is often used to open drop-down lists or filter menus.
- Ctrl + Down Arrow moves the active cell to the last non-empty cell in the current column downwards, without extending the selection.