Graphs and Charts for Business Data – important questions for Boards 2027

CBSE Class 12 Accountancy

1. MCQ · 1 mark

   Which chart element includes the entire chart and all its elements? (A) Plot area (B) Chart area (C) Legend (D) Data label

   Answer

   (B) Chart area — it includes the entire chart and all its elements.

2. SA · 2 marks

   What tabs appear under Chart Tools when you click anywhere in a chart?

   Answer

   Clicking anywhere in a chart displays Chart Tools with the Design, Layout and Format tabs. These tabs allow chart elements, including plot area, axes, data, titles, labels, legends and gridlines, to be formatted and edited.

3. LA · 4 marks

   Describe the steps for selecting the product-wise total sales data and choosing a bar chart for it from the Ribbon.

   Answer

   A bar chart can display the product-wise total sales data entered in the worksheet. 1. Locate the product names and their corresponding total sales values in the worksheet. The product-wise totals are given in the column total cells. 2. Select the product names together with their total sales values so that Excel can use the products as categories and the totals as data. 3. Open the Insert tab on the Ribbon and click the Charts group to view the available chart types. 4. Choose the Bar Chart option from the chart choices. Excel uses the selected product-wise data to prepare the chart. The resulting bar chart presents total sales for each product for comparison.

4. LA · 5 marks

   Explain how positive and negative values are positioned on the X- and Y-axes relative to the origin. Distinguish between the axes of 2-D and 3-D charts, and state how height, length and breadth represent volume. (5 marks)

   Answer

   1. Position relative to the origin — 2-D: The intersection of the X-axis and Y-axis is the origin; positive X-values lie to its right and negative X-values to its left, while positive Y-values lie above it and negative Y-values below it. 3-D: The X- and Y-axes retain these positions, with an additional depth axis. 2. Axes — 2-D: The horizontal X-axis represents categories and the vertical Y-axis represents data or derived values. 3-D: The chart has these two axes and a third depth axis, also called the series axis or Z-axis. 3. Representation of volume — 2-D: The chart represents length and height on the X- and Y-axes. 3-D: Volume is represented using length on the X-axis, height on the Y-axis and breadth on the Z-axis.

5. VSA · 1 mark

   What is the maximum number of categories that an Excel pie chart can plot?

   Answer

   An Excel Pie chart can plot a maximum of seven categories, each representing a part of the whole.

6. SA · 2 marks

   State what can be changed using the Design option, including what Switch Row/Column does in a 2-D chart.

   🔒 Answer locked. Unlock all answers on SmartKalike

7. LA · 4 marks

   Explain how to access Excel’s chart-type choices using the Ribbon, naming the relevant tab and group and describing how this route is used when preparing a chart.

   🔒 Answer locked. Unlock all answers on SmartKalike

8. LA · 5 marks

   Distinguish between the information conveyed by pie charts and bar charts. Then name the main elements in Excel chart nomenclature and state which Excel tools are used to format chart elements.

   🔒 Answer locked. Unlock all answers on SmartKalike

9. SA · 2 marks

   Describe how to select a chart element and open its formatting options using the Format tab.

   🔒 Answer locked. Unlock all answers on SmartKalike

10. LA · 4 marks

    Explain how to select a chart layout and style using the Design tab. Then describe how bevel and material effects and a shadow can be applied to a 3-D pie chart, and how its first slice can be rotated by specifying an angle.

    🔒 Answer locked. Unlock all answers on SmartKalike