CBSE Class 12 Accountancy 2026: question 28
Set in the CBSE Class 12 board exam of 2026, paper 67/5/1, section B-II, question 28, for 1 mark. Try it first; the hints and our step-by-step solution are below.
Q28 · 1 mark · MCQSpreadsheet
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 ?
- (A)END + Down arrow ()
- (B)HOME + Page down
- (C)HOME + Down arrow ()
- (D)CTRL + Down arrow () successively
Source: official question paper from cbse.gov.in (PDF). See it in the full 2026 board paper, set 67/5/1.
Hints
Open one hint at a time and try again before the next.
Hint 1
Which key, pressed before an arrow, makes the cursor jump to the end of a data block?
Hint 2
HOME takes you to the start of a row, not the end of data.
Step-by-step solution
Each step shows the marks it earns, as an examiner would award them. Checked by an independent re-solve from the question paper.
Pressing END switches on End mode; the next arrow key jumps to the edge of the current block of data.
- 1 mark
So END followed by the Down arrow moves from the first to the last cell of the data cluster in a column, skipping the cells between. Option (A).
Answer: (A) END + Down arrow
Where the marks are
- END + Down arrow (1 mark)
Revise the chapter
- Chapter: Spreadsheet (notes, formulas, where marks are lost and every past question)
More questions from Spreadsheet
- 2026 board paper, set 67/5/1, Q30(a) · 1 mark#NAME? Error indicates :
- 2026 board paper, set 67/5/1, Q33(a) · 4 marksGive the meaning of the following : (i) Cell reference (ii) Relative cell reference (iii) Absolute cell refere…
- Sample paper 2025-26, Q33(b) · 4 marksWhat are the uses of ‘Error Alert tab’?
The question is transcribed from the official paper; figures are described in words. The solution, hints and chapter tag are ours. Spotted an error? Write tosupport@questionbuddy.in.