Skip to content

'In MS Excel, charts can… (Class 12 Accountancy 2026, Q34)

questionbuddy.in/q/cbse-12-accountancy-2026-67-5-1-q34-excel-charts-can-formatted-customised

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

CBSE Class 12 Accountancy 2026: question 34

Set in the CBSE Class 12 board exam of 2026, paper 67/5/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 answerGraphs and Charts for Business Data

'In MS Excel, charts can be formatted and customised to make them more attractive and meaningful.' Explain the procedure to change the shape style of a chart element. Also state various shape fill options available to the user for enhancing the appearance of a chart.

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

Shape styles live on the Format tab of Chart Tools.

Hint 2

List what Shape Fill can fill a shape with: colours, picture, gradient, texture.

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. Changing the shape style: select the chart element, go to the Format tab and use the Shape Styles group. Click the More button to see all shape styles.

    1 mark

  2. To apply a predefined shape style, click the style wanted in the Shape Styles box.

    1 mark

  3. Shape Fill options (Format tab → Shape Fill): pick a colour under Theme Colours or Standard Colours; or choose No Fill to remove colour.

    1 mark

  4. Choose More Fill Colours to set a custom colour on the Standard or Custom tab of the Colours dialog box; custom colours then appear under Recent Colours.

    1 mark

  5. Choose Picture to fill the shape with an image chosen in the Insert Picture dialog box.

    1 mark

  6. Choose Gradient to apply a gradient variation (or More Gradients for more), or Texture to fill with a texture.

    1 mark

Answer: Format tab → Shape Styles (More button or a predefined style); Shape Fill options: theme/standard colour, No Fill, More Fill Colours, Picture, Gradient, Texture

Where the marks are

  • Steps to change shape style (2 marks)
  • Shape fill options: colour, no fill, more colours, picture, gradient, texture (4 marks)

Revise the chapter

Practise this chapterBoard-style questions from Graphs and Charts for Business Data, one at a time, marked against the answer key and marking points.Back to the full paper2026 board paper, set 67/5/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.