Skip to content

Explain various options… (Class 12 Accountancy 2026, Q34)

questionbuddy.in/q/cbse-12-accountancy-2026-67-1-1-q34-various-available-change-alignment-text

AccountancyCBSE Class 12 · Board exam 2026, set 67/1/1 · 6 marks · Long answer

CBSE Class 12 Accountancy 2026: question 34

Set in the CBSE Class 12 board exam of 2026, paper 67/1/1, 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

Explain various options available to change the alignment of the text in the cells.

Source: official question paper from cbse.gov.in (PDF). See it in the full 2026 board paper, set 67/1/1.

Hints

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

Hint 1

Look at the Alignment group on the Home tab.

Hint 2

Think of position, angle and fit of text in a cell.

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. Opening the options. Select the range, then open the Alignment group on the Home tab (or Format Cells → Alignment tab), choose the settings and click OK.

    1 mark

  2. Text alignment: horizontal (left, centre, right, justify) and vertical (top, middle, bottom) position of text in the cell.

    1 mark

  3. Orientation / text direction: text can be rotated to an angle or set to read in a chosen direction.

    1 mark

  4. Text control: wrap text within the cell, shrink to fit (autofit the text to the cell) or merge cells so that text spreads across them.

    1 mark

  5. Internal margins and indent: the space between the text and the cell or element border can be set on the left, right, top and bottom (and indent from the edge), and text can be placed in columns.

    2 marks

Answer: Home → Alignment (Format Cells): horizontal and vertical alignment, orientation/text direction, wrap text, shrink to fit/autofit, merge cells, and internal margins/indent

Where the marks are

  • Procedure (1 mark)
  • Horizontal and vertical alignment (1 mark)
  • Orientation (1 mark)
  • Text control (1 mark)
  • Margins and indent (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 paper2026 board paper, set 67/1/1: 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.