Skip to content

What is meant by… (Class 12 Accountancy SQP 2025-26, Q34)

questionbuddy.in/q/cbse-12-accountancy-2025-26-sqp-q34-meant-merging-range-cells-how

AccountancyCBSE Class 12 · Sample paper, session 2025-26 · 6 marks · Long answer

CBSE Class 12 Accountancy sample paper 2025-26: question 34

From the official CBSE sample question paper for 2025-26, section B-II, question 34, for 6 marks. Try it first; the hints and our step-by-step solution are below.

Q34 · 6 marks · Long answerSpreadsheet

What is meant by ‘Merging a range of cells’? How is it done? State the steps to split a merged cell.

Source: official sample paper from cbseacademic.nic.in (PDF). See it in the full Sample paper 2025-26.

Hints

Open one hint at a time and try again before the next.

Hint 1

Which cell's address does a merged cell keep?

Hint 2

Look in the Alignment group of the Home tab.

Hint 3

Splitting is the same button pressed again.

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.

  1. Meaning. Merging joins two or more adjacent cells (across rows or columns) into one larger cell. The merged cell takes the address of the upper-left cell, and only that cell's content is kept, usually centred.

    2 marks

  2. How to merge. Select the adjacent cells; on the Home tab, in the Alignment group, click Merge & Center (or choose Merge Across / Merge Cells from its drop-down).

    2 marks

  3. Steps to split a merged cell. (1) Select the merged cell; the Merge & Center button shows as selected. (2) Click Merge & Center again (or choose Unmerge Cells). The content goes back to the upper-left cell of the range.

    2 marks

Answer: Merging combines adjacent cells into one cell addressed by its upper-left cell; done with Home → Alignment → Merge & Center; split by selecting the merged cell and clicking Merge & Center (Unmerge) again

Where the marks are

  • Meaning of merging (2 marks)
  • Steps to merge (2 marks)
  • Steps to split (2 marks)

Revise the chapter

  • Chapter: Spreadsheet (notes, formulas, where marks are lost and every past question)
Practise this chapterBoard-style questions from Spreadsheet, one at a time, marked against the answer key and marking points.Back to the full paperSample paper 2025-26: every question, by section.

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.