Question:
How is navigation conducted from the first to the last cell in a cluster of data in a column by skipping all the cells in between?
How is navigation conducted from the first to the last cell in a cluster of data in a column by skipping all the cells in between?
Show Hint
Excel Navigation Shortcuts:
- END + Arrow \(\Rightarrow\) Jump to edge of data region
- Ctrl + Arrow \(\Rightarrow\) Also jumps to edge of data region (modern versions)
- Ctrl + Home \(\Rightarrow\) Go to cell A1
- Ctrl + End \(\Rightarrow\) Go to last used cell
Updated On: Mar 9, 2026
- END + Down arrow (↓)
- HOME + Page down
- HOME + Down arrow (↓)
- "TR1. + Down arrow (↓) successively
Show Solution
Verified By Collegedunia
The Correct Option is A
Solution and Explanation
We need to identify the correct keyboard shortcut to navigate from the first to the last cell in a data cluster in a column, skipping intermediate cells.
Step 1: Understand Excel navigation shortcuts.
In Excel, to quickly move to the edge of a data region (last contiguous cell with data in a column or row), you use the END key followed by an arrow key.
Step 2: Specific shortcut for moving to the last cell in a column of data.
Step 1: Understand Excel navigation shortcuts.
In Excel, to quickly move to the edge of a data region (last contiguous cell with data in a column or row), you use the END key followed by an arrow key.
Step 2: Specific shortcut for moving to the last cell in a column of data.
- To go from the first cell to the last cell in a continuous data range in a column:
- Press END key, then press Down Arrow (↓)
- This will jump to the last cell with data in that column before an empty cell.
- If the column has data continuously without blanks, it will take you to the last cell with data.
- (A) END + Down arrow (↓):
- ✓ Correct. This is the standard shortcut to jump to the last cell in a data region in a column.
- (B) HOME + Page down:
- HOME key moves to the beginning of a row, and Page Down moves down one screen, not to the last data cell.
- This combination is not standard.
- (C) HOME + Down arrow (↓):
- HOME + Down arrow does not have a special function; HOME moves to column A, then Down arrow moves down one cell.
- Not for jumping to the last data cell.
- (D) "TR1. + Down arrow (↓) successively:
- This appears to be a typo or corrupted text. Probably meant "Ctrl + Down arrow" which also works to jump to the last cell with data.
- However, Ctrl + Down arrow is also valid, but the given option has "TR1." which is incorrect.
- The standard and most commonly mentioned shortcut is END + Down arrow.
Was this answer helpful?
0
0
Top CBSE CLASS XII Accountancy Questions
From the following Balance Sheet of Hira Ltd. as at 31st March, 2023, prepare Comparative Balance Sheet:
- On 1st May, 2023, Amrit Ltd. issued 10,000, 10% debentures of ₹100 each at a premium of 10%, redeemable at a premium of 10%. Loss on issue of debentures will be:
- Gupta and Sharma are partners in a firm sharing profit in the ratio of 4:1. They admitted Preeti as a new partner for \( \frac{1}{4} \) share in the profits, which she acquired wholly from Gupta. The new profit sharing ratio of Gupta, Sharma, and Preeti will be:
- On the dissolution of a partnership firm, there were debtors of ₹34,000. Debtors of ₹1,000 became bad, and 60% was realized from the remaining debtors. Which account will be debited and by how much amount on the realization from debtors?
- If vendors are issued fully paid shares of ₹1,25,000 in purchase consideration of net assets of ₹1,50,000, the balance of ₹25,000 will be credited to:
View More Questions
Top CBSE CLASS XII Computerised Accounting Questions
- Computerised Accounting System rests on Five Pillars: Data, People, Procedure and _____, _____.
Identify the blank pillars from the following: Which of the following is not a limitation of Computerised Accounting System?
- MS Excel considers which of the following group of mathematical operations to be of equal importance?
- How is navigation conducted from first to last cell in a cluster of data in a column by skipping all the cells in between?
- Individual values represented by bars, columns, lines, pie or various forms plotted on a chart are known as:
View More Questions
Top CBSE CLASS XII Questions
- 2, b, c are in A.P. and the range of determinant $\begin{vmatrix}1&1&1\\ 2&b&c\\ 4&b^{2}&c^{2}\end{vmatrix}$ is [2, 16]. Then find range of c is
- A boy of mass 50 kg is standing at one end of a, boat of length 9 m and mass 400 kg. He runs to the other, end. The distance through which the centre of mass of the boat boy system moves is
- A capillary tube of radius r is dipped inside a large vessel of water. The mass of water raised above water level is M. If the radius of capillary is doubled, the mass of water inside capillary will be
- A circular disc is rotating about its own axis. An external opposing torque 0.02 Nm is applied on the disc by which it comes rest in 5 seconds. The initial angular momentum of disc is
- A circular disc is rotating about its own axis at uniform angular velocity \(\omega.\) The disc is subjected to uniform angular retardation by which its angular velocity is decreased to \(\frac {\omega}{2}\) during 120 rotations. The number of rotations further made by it before coming to rest is
View More Questions