CBSE Class 12 Accountancy sample paper 2025-26: question 33(a)
From the official CBSE sample question paper for 2025-26, section B-II, question 33(a), for 4 marks. Try it first; the hints and our step-by-step solution are below.
Q33(a) · 4 marks · Long answerGraphs and Charts for Business Data
State steps to be taken in preparation of a chart.
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
A chart starts from data laid out in rows and columns.
Hint 2
After inserting, think about appearance and labelling.
Hint 3
Finish with placing and saving the chart.
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 mark
Enter the data in a worksheet with proper row and column titles, then select it and create a basic chart from the Charts group of the Insert tab.
- 1 mark
Change the chart type, layout or style, and format chart elements as needed.
- 1 mark
Add or remove the chart title, axis titles and data labels; show or hide the legend, axes and gridlines.
- 1 mark
Move or resize the chart and save it with the workbook.
Answer: Enter data → create basic chart → change layout/style → add titles and labels, legend, axes and gridlines → move/resize and save
Where the marks are
- Data entry and basic chart (1 mark)
- Layout and style (1 mark)
- Titles, labels, legend, axes (1 mark)
- Move/resize and save (1 mark)
Revise the chapter
- Chapter: Graphs and Charts for Business Data (notes, formulas, where marks are lost and every past question)
- Topic: Steps to Create a Chart
More questions from Graphs and Charts for Business Data
- 2026 board paper, set 67/1/1, Q32 · 3 marksWhat are 'Radar Charts' ? What purpose do they serve ?
- 2026 board paper, set 67/5/1, Q34 · 6 marks'In MS Excel, charts can be formatted and customised to make them more attractive and meaningful.' Explain the…
- Sample paper 2025-26, Q27(a) · 1 markA ‘legend’ can be repositioned on the chart:
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.