Everything you need to ace this chapter, in one place.
Notes · Mind Map · Quiz · Assertion-Reason · Case Studies · Question Bank · Past Papers
Q1. Which of the following best describes a pie chart?
Answer: A — A pie chart specifically shows how one variable is divided into sub-groups, with each slice representing a proportion of the whole.
Q2. What are the two essential axes present in any basic graph?
Answer: B — Every basic 2-dimensional graph must have an X-axis (horizontal, containing categories) and a Y-axis (vertical, containing data values).
Q3. Which Excel tab is used to insert a chart or graph?
Answer: C — The Insert tab on the Excel Ribbon contains the Charts group with tools to create various types of graphs and charts.
Q4. In Excel chart creation, what is the purpose of the Design tab?
Answer: B — The Design tab allows users to modify the chart's appearance by changing type, layouts, styles, and switching how data is organized (rows to columns).
Q5. What is a data series in a chart?
Answer: B — A data series consists of related data points in a chart, each represented in a unique colour or pattern and identified by the legend.
Q6. Which chart element identifies and explains the different data series or categories in a chart?
Answer: C — The legend is the key component that shows what each colour, pattern, or symbol in the chart represents, enabling readers to understand the data series.
Q7. If quarterly sales data shows QTR1: 25,844, QTR2: 11,295, QTR3: 14,744, QTR4: 21,886, which chart type would best visualize the trend across quarters?
Answer: B — A column or line chart effectively displays how sales change over the four quarters, making trends and comparisons immediately visible.
Q8. What is the plot area in a 2-D chart?
Answer: B — The plot area is specifically the region enclosed by the horizontal and vertical axes where the actual data points (bars, lines, etc.) are displayed.
Q9. Which of the following is NOT a basic element of a chart? (A) Chart area, (B) Plot area, (C) Spreadsheet formula, (D) Data labels
Answer: C — Chart, plot area, data labels, legend, titles, and axes are all chart elements; spreadsheet formulas are tools used to calculate data but not a chart component itself.
Q10. To swap the X-axis data (Products) with the Y-axis data (Quarters) in an existing Excel chart, which sequence of steps is correct? (I) Click anywhere in the chart to display Chart Tools, (II) Go to Design tab, (III) Click the arrow at Switch Row/Column box
Answer: C — All three steps must be followed in sequence: first click in the chart to activate Chart Tools, then access the Design tab, then use the Switch Row/Column feature.
What is a graph in data presentation?
A pictorial representation of data with at least 2-dimensional relationship (X-axis and Y-axis).
What does a pie chart represent?
Multiple sub-groups of a single variable shown as proportional slices.
What is the difference between a bar diagram and a pie chart?
Bar diagram depicts two or more variables, while pie chart shows sub-groups of only one variable.
Name the two axes in a basic graph.
X-axis (horizontal, contains categories) and Y-axis (vertical, contains data values).
What is a data series in a chart?
Related data points plotted in a chart, each shown in a unique colour or pattern, identified by the legend.
What is the plot area in a 2-D chart?
The area bounded by the X and Y axes where data markers are plotted.
What is the purpose of a legend in a chart?
To identify and explain the data series or different categories represented by colours or patterns in the chart.
What does the chart area include?
The entire chart including all elements such as plot area, axes, titles, legend, and data markers.
What is a data marker?
An individual value plotted in a chart, represented by bars, columns, lines, pie slices, or other shapes.
How can you swap row and column data in an Excel chart?
Click the chart, go to the Design tab, and click the arrow at the Switch Row/Column box.
Define a graph and explain how it differs from a pie chart in representing business data. [2 marks]
Graph requires 2 dimensions (X, Y axes) and shows relationships/trends; pie chart shows sub-groups of one variable only. Give one example for each.
Explain with an example how the elements of a chart (plot area, legend, data series, axis titles) help in communicating accounting information clearly to stakeholders. [5 marks]
Define each element briefly; show how together they make financial data (e.g., quarterly sales) understandable at a glance. Use ABC Manufacturing Company's quarterly sales example from notes.
The finance manager of XYZ Ltd. has created a column chart showing monthly revenue for six quarters (Q1–Q4 of two years). However, stakeholders want to see the same data rearranged so that each revenue stream (Product A, B, C) is on the X-axis and months are on the Y-axis. Explain the complete Excel procedure to restructure this chart, naming all steps and relevant toolbar options involved. [6 marks]
Step 1: Click in chart to activate Chart Tools (Design, Layout, Format tabs appear); Step 2: Use Design tab → Data group → Switch Row/Column button; Step 3: Explain how rows (months) and columns (products) swap positions. Include why design formatting matters for clarity.
Q1. Assertion (A):
A pie chart is the most appropriate choice for displaying the composition of total annual revenue across five product categories.
Reason (R):
Pie charts represent multiple sub-groups of a single variable and show the proportional contribution of each category to the whole.
Answer: A — Both A and R are true, and R is the correct explanation of A — Both statements are true, and the reason directly explains why pie charts are suitable for showing composition. A pie chart's circular segments clearly display what percentage or proportion each product contributes to total revenue.
Q2. Assertion (A):
The legend in a chart serves to identify individual data markers by assigning colours or patterns.
Reason (R):
Data labels provide additional information about specific data points and replace the need for a legend in multi-series charts.
Answer: C — A is true but R is false — The assertion is true—legends identify data series through unique colours/patterns. However, the reason is false; data labels show specific values and do NOT replace legends. Both elements serve different identification purposes in multi-series charts.
Q3. Assertion (A):
In MS Excel, the 'Switch Row/Column' function located in the Design tab swaps which data is displayed on the X-axis versus the Y-axis.
Reason (R):
This function allows reorganization of data presentation without altering the actual underlying worksheet data.
Answer: B — Both A and R are true, but R is NOT the correct explanation of A — Both statements are true. The function does swap axis assignment (Products on X becomes Quarters on X), and it affects only the chart's visual presentation, not the source data. However, the reason does not explain how or why the axis swap occurs—it only clarifies that source data remains unchanged.
Unlock more Assertion-Reason questions in Premium — unlock →
Case Study:
TechVision Ltd., an IT services company, prepared quarterly financial data for the fiscal year 2023-24. The company's revenue (in ₹ crores) from five service segments—Software Development, Cloud Services, Cybersecurity, Data Analytics, and Consulting—was tracked across all four quarters. The data analyst needs to create visual representations to present this information to the board of directors. The analyst is considering multiple chart options: a pie chart to show annual revenue composition by segment, a clustered bar chart to compare quarterly performance across segments, and a line graph to display revenue trends over the year. The company's total annual revenue was ₹320 crores, with Cloud Services contributing 35%, Software Development 25%, Cybersecurity 20%, Data Analytics 15%, and Consulting 5%.
Q1. Which chart type would be most appropriate for the board to quickly understand each service segment's contribution to the total annual revenue of ₹320 crores?
Answer: B
Q2. If TechVision Ltd. wants to present data comparing how each service segment's revenue varied across Q1, Q2, Q3, and Q4, which chart element would be essential to include for clear interpretation?
Answer: A
Q3. In Excel, if the analyst initially creates a clustered bar chart with service segments on the X-axis and revenue values on the Y-axis, what function would allow switching the display to show quarters on the X-axis instead?
Answer: B
Q4. Cloud Services contributed ₹112 crores (35% of ₹320 crores) annually. If this segment's revenue is displayed as a data marker in a bar chart, what is the primary function of the legend in helping the board interpret this information?
Answer: B
Unlock more case studies in Premium — unlock →
Real CBSE board exam questions from past papers — free to attempt.
CBSE 2026 · Set 67/3/1 · 1 mark
________ provides additional information about a data marker to identify the details of data point in a data series.
CBSE 2026 · Set 67/3/1 · 4 marks
What is a Chart/Graph? Explain its advantages.
CBSE 2026 · Set 67/4/2 · 1 mark
A column chart can be changed to a pie chart because: I. Only one data series is used to plot it. II. The plotted data values are positive. III. The data values are not equal to zero also. IV. More than seven categories of data can be represented. Identify the correct option :
CBSE 2026 · Set 67/4/3 · 1 mark
A column chart can be changed to a pie chart because: I. Only one data series is used to plot it. II. The plotted data values are positive. III. The data values are not equal to zero also. IV. More than seven categories of data can be represented. Identify the correct option:
CBSE 2026 · Set 67/5/1 · 6 marks
Explain the steps involved in formatting the style of a chart element in MS Excel. Also state various shape fill options available to the user for enhancing the appearance of a chart.
CBSE 2026 · Set 67/5/2 · 6 marks
Explain various options available to a user to change the shape outline of a chart element to improve its visual appearance.
CBSE 2026 · Set 67/5/3 · 6 marks
A company wants to present its sales data for last five years in a graphical form using MS Excel. As a student of Computerised Accounting, state steps to create a chart in Excel to represent the data visually.
CBSE 2025 · Set 67/4/2 · 3 marks
Write the advantages of using Graphs.
CBSE 2025 · Set 67/5/1 · 4 marks
State the steps to prepare a chart.
CBSE 2025 · Set 67/6/1 · 1 mark
Which chart element provides additional information about a data marker to identify the details of data in data series?
CBSE 2025 · Set 67/7/1 · 1 mark
(b) Individual values represented by bars, columns, lines, pie or various forms plotted on a chart are known as :
CBSE 2025 · Set 67/7/2 · 1 mark
Individual values represented by bars, columns, lines, pie or various forms plotted on a chart are known as:
See all 22 board PYQs for this chapter — open PYQ tab →
Every formula, ratio and format from all 10 chapters on one page, checked against the NCERT textbook and the CBSE 2026-27 syllabus. Free PDF download.
All 1230 CBSE board questions from 2022–2026, sorted by chapter and question type. Free PDF download.
You've seen the free preview. Open the full interactive study kit — mind map, instant-graded quiz, progress tracking — free, no sign-in required.
Open Full Study Kit — Free →Premium unlocks the full Question Bank, Daily Practice Papers, Chapter Quiz and Full Mock Papers for every chapter.