✓ 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.
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 :
1. Select two or more adjacent cells that need to be merged
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
merge cell will be the address of lower active cell.
Split a merged cell :
1. Select the merged cell
2. When we select a merged cell the merge and centre button also appears selected in the
alignment group on the Home tab
3. To split the merged cell, click merge and centre. The contents of the merged cell will
appear in the upper left cell of the range of split cells
More from Spreadsheet
- Explain the two syntax forms of 'Lookup' function.2024
- Explain various 'Data tables' used in 'Pivot Table.2024
- Using the worksheet find out the error and its reason for the given 'VLOOKUP' syntax. (i) = VLOOKUP (B1, B2: E8, 2, 0) (ii) = SQRT (VLOOKUP (B5, B8:…2024
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct it.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 it.2025
- From the given 'VLOOKUP' syntax find out the error and its reason using the worksheet. (i) = VLOOKUP (B5, C3: F10, 2, 0) (ii) = SQRT (VLOOKUP (B3,…2024
- Give the meaning of the terms Report and Report Wizard'.2022
CBSE Class 12 Accountancy past-paper question from the 2026 board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.