Skip to main content
Super TutorResources
Chapter 12 of 14
QuestionsNotesFlashcardsSummaryFormulasQuizConceptsSyllabusPlan
NCERT Solutions

Graphs and Charts for Business Data

CBSE · Class 12 · Accountancy

NCERT Solutions for Graphs and Charts for Business Data — CBSE Class 12 Accountancy.

66 questions72 flashcards5 concepts

Interactive on Super Tutor

Studying Graphs and Charts for Business Data? Get the full interactive chapter.

Quizzes, flashcards, AI doubt-solver and a step-by-step study plan — built for ncert solutions and more.

Try Super Tutor — Free

1,000+ Class 12 students started this chapter today

32 Questions Solved · 3 Sections

16 worked solutions below. Unlock all 32 free in Super Tutor

Q1. MULTIPLE CHOICE QUESTIONS

1To change the location of a chart, right-click the chart and select:Show solution
To change a chart's location, the correct command is Move here.

Not sure why a step works? check your working in Super Tutor

2The Ribbon allows us to:Show solution
The Ribbon allows us to create either an embedded chart or a chart sheet chart.

Not sure why a step works? check your working in Super Tutor

3Once we have created a chart we may change _____:Show solution
After creating a chart, we may change the formatting for text like titles and data labels.

Not sure why a step works? check your working in Super Tutor

4In Excel the chart tools provides three different options _____, _____ and _____ for formatting:Show solution
The three chart tools options are Design, Layout, and Format.

Not sure why a step works? check your working in Super Tutor

5Pie chart don't have more than _____ categories:Show solution
The chapter states that a pie chart cannot plot more than seven categories.

Not sure why a step works? check your working in Super Tutor

6Column charts are useful for _____:Show solution
Column charts are useful for both showing changes over time and illustrating comparisons among items.

Not sure why a step works? check your working in Super Tutor

7Doughnut charts:Show solution
A doughnut chart contains more than one data series and is comparable with a pie chart.

Not sure why a step works? check your working in Super Tutor

8The 2D graph using ______, ______ axes and in 3D graph ______ axis is also used.Show solution
A 2-D graph uses category and value axes, and a 3-D graph also uses the series axis.

Not sure why a step works? check your working in Super Tutor

9Excel automatically redraws the chart ______:Show solution
Excel redraws the chart automatically if there is any change in the data or the range data.

Not sure why a step works? check your working in Super Tutor

10Legend can be repositioned on the chart:Show solution
A legend can be repositioned anywhere on the chart.

Not sure why a step works? check your working in Super Tutor

11Which chart element details the data values and categories below the chart?Show solution
Data labels show the data values and categories below the chart.

Not sure why a step works? check your working in Super Tutor

12From what command tab is the font size for an axis in a chart changed?Show solution
The font size for an axis is changed from the Home tab.

Not sure why a step works? check your working in Super Tutor

13Which of these purposes does not pertain to charts?Show solution
Charts help in identifying trends, recognising patterns, and making comparisons; selecting values is not one of their purposes.

Not sure why a step works? check your working in Super Tutor

14What do you see if you move over the mouse over a chart object?Show solution
When you move the mouse over a chart object, you see a ChartTip.

Not sure why a step works? check your working in Super Tutor

15Which group on the Chart Tools Format tab shows the name of the selected element?Show solution
The group that shows the selected element's name is Current Selection.

Not sure why a step works? check your working in Super Tutor

Q2. ANSWER THE FOLLOWING QUESTIONS

1Define charts, graphs and how they are useful in business decisions?Show solution
A graph/chart is a pictorial representation of data. It helps business decisions because data can be understood quickly, trends and patterns can be seen easily, comparisons can be made, and information can be presented and conveyed in a simple visual form instead of raw numbers.

Not sure why a step works? check your working in Super Tutor

2Write down the usage and purpose of column chart, pie chart and line chart.
3Describe about data series, legend, and data labels??
4Describe use of Excel for preparation of chart.
5Differentiate between pie charts, line charts and column charts respectively?
6Described the steps to move, resizing and reposition a chart.
7What does percentage in chart represent and how it being calculated by the software?
8What are the differences between
9What is pie chart and what are percentage values means in pie chart?
10Different types of charts which can be prepared using Excel?

Q3. SKILL REVIEW

A.Create a trend chart after filling data in to the worksheet.
B.Create a Pie chart to compare data from above table for Total (column number 3).
C.Draw a Trend charts for each male, female and totals separately.
D.Draw a Column Chart for the above data for each (male, female and total) separately for Literate and Illiterate.
E.Prepare a Pie chart and Column chart for the 10 different plots areas 5, 7, 8, 9, 8, 10, 4, 6, 7 and 3 hectares respectively.
F.Draw a Pie chart for the following data on vehicles registered in the RTO department during 2007-08 in your city.
G.Draw a Column chart for the following data.

16 more solved questions in Graphs and Charts for Business Data

Every remaining exercise is solved step by step in Super Tutor, plus practice quizzes and flashcards for this chapter. Free to start.

Stuck on a step?

Ask Super Tutor AI to explain any solution on this page in a simpler way — free, 24x7.

Ask a Doubt Free

Frequently Asked Questions

What are the important topics in Graphs and Charts for Business Data for CBSE Class 12 Accountancy?
Graphs and Charts for Business Data covers several key topics that are frequently asked in CBSE Class 12 board exams. Focus on the core concepts listed on this page and practise related questions to build confidence.
How to score full marks in Graphs and Charts for Business Data — CBSE Class 12 Accountancy?
Understand the core concepts first, then work through the 66 practice questions available for this chapter. Revise formulas and definitions regularly, and use flashcards for quick recall before the exam.
Where can I get free NCERT Solutions for Graphs and Charts for Business Data Class 12 Accountancy?
This page has free step-by-step NCERT Solutions for every exercise question in Graphs and Charts for Business Data (CBSE Class 12 Accountancy) — written the way examiners award marks: given, formula, working, answer.

Sources & Official References

Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.

More resources for Graphs and Charts for Business Data

All 14 chapters — CBSE Class 12 Accountancy NCERT Solutions

For serious students

Get the full Graphs and Charts for Business Data chapter — for free.

Quizzes, flashcards, AI doubt-solver and a step-by-step study plan for CBSE Class 12 Accountancy.

Try Super Tutor Free
Try the full chapter — Free