When Extend Selection is active, what is the keyboard shortcut for selecting all data up to and including the last row?
Answer & explanation
Correct answer: option 3
The correct answer is Option (3) → [Ctrl]+[Shift]
Extend Selection is the mode in which the selection grows from the active cell as you move, instead of the cursor only jumping. To take the selection down to the last row of data, the keys held are [Ctrl]+[Shift], used with the arrow pointing down the column.
[Ctrl]+[Down Arrow] and [Ctrl]+[Up Arrow] on their own are navigation keys: they move the cursor to the last or first filled cell of the column. [Ctrl]+[Home] takes the cursor to cell A1.
NCERT (2026-27 edition):
|
