Question

How is navigation conducted from first to last cell in a cluster of data in a column by skipping all the cells in between?

• A. Home + Page down
• B. Home + Down arrow (↓)
• C. End + Down arrow (↓)
• D. CTRL + Down arrow (↓) successively

Hint:

Use End + Arrow keys in Excel to navigate quickly through continuous blocks of data without selecting intermediate cells.

Answer 1

The Correct Option is C

To jump from the top to the bottom of a continuous data range in Excel:
\(\Rightarrow\) Use End + Down Arrow (↓) to skip empty cells and directly reach the last filled cell in the column.
- Home + Page Down navigates partially but not vertically through filled cells.
- CTRL + Down Arrow is also used, but End + Down Arrow specifically scans up to the last cell in sequence.