✓ Board-verified
Accountancy · 2026 · 6 marks
CBSE 2026 · Region 1 · Set 3 · Q34
How will you combine multiple cells into one in MS-Excel ? What steps will you follow to reverse the process ? Explain.
Marking-scheme solution
Steps to combine multiple cells :
merged………………...…….1
1. Select two or more adjacent cells that need to be
……………..….1
2. On the Home, in the alignment group click merge and centre.
3. To merge cell without centering, click the arrow next to merge cells. The cell address of
……………………………….1
merge cell will be the address of lower active cell.
Split a merged cell :
cell………………………………………………….……….1
1. Select the merged
2. When we select a merged cell the merge and centre button also appears selected in the
alignment group on the Home tab…………………………..…………………….1
3. To split the merged cell, click merge and centre. The contents of the merged cell will
cells…………………………….1
appear in the upper left cell of the range of split
More from Spreadsheet
- Explain the two syntax f2024
- Explain various 'Data tables' used in 'Pivot Table.2024
- QQ Cut.11 v Wrap Text iCaliba'i I. Copy v Paste I u~ v -v A Merge 81 Center v v 1) format Painter E Clipboard…2024
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct…2025
- What is a 'Pivot table'? State any three of its advantages. OR List eight uses of Accounting Software.2023
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct…2025
- iCalibfi 11 'A A' I ® ' Wrap Text % Copy v Paste I Ll v; E Merge 8z Center v 'X Format Painter Clipboard Font…2024
- Give the meaning of the terms Report and Report Wizard'.2022
CBSE Class 12 Accountancy past-paper question from the 2026board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.