Advertisements
Online Mock Tests
Chapters
2: Spreadsheet
3: Use of Spreadsheet in Business Applications
▶ 4: Graphs and Charts for Business Data
![NCERT solutions for अकाऊंटन्सी कॉम्प्युटराइज्ड अकाउंटिंग सिस्टम [इंग्रजी] इयत्ता १२ chapter 4 - Graphs and Charts for Business Data - Shaalaa.com](/images/accountancy-computerised-accounting-system-english-class-12_6:1ee30da456684c3db22d6e312c1ecda4.jpg "NCERT solutions for अकाऊंटन्सी कॉम्प्युटराइज्ड अकाउंटिंग सिस्टम [इंग्रजी] इयत्ता १२ chapter 4 - Graphs and Charts for Business Data")
Advertisements
Solutions for Chapter 4: Graphs and Charts for Business Data
Below listed, you can find solutions for Chapter 4 of CBSE NCERT for अकाऊंटन्सी कॉम्प्युटराइज्ड अकाउंटिंग सिस्टम [इंग्रजी] इयत्ता १२.
NCERT solutions for अकाऊंटन्सी कॉम्प्युटराइज्ड अकाउंटिंग सिस्टम [इंग्रजी] इयत्ता १२ 4 Graphs and Charts for Business Data EXERCISE [Pages 120 - 123]
MULTIPLE CHOICE QUESTIONS
To change the location of a chart, right-click the chart and select ______.
Chart Type.
Source Data.
Chart Options.
Move here.
The Ribbon allows us to ______.
Create either an embedded chart or a chart sheet chart.
Create only an embedded chart.
Create only a chart sheet chart.
Change the data values used to create the chart.
Once we have created a chart, we may change ______.
the formatting for text like titles and data labels.
only by going back through the ribbon.
everything about the chart.
the data series patterns only.
In Excel, the chart tools provide three different options _____, _____ and _____ for formatting.
Layout, Format, Data Maker
Design, Layout, Format
Format, Layout, Label
Design, DataMaker, Layout
Chart Layouts, Chart Style, Label.
Pie chart don’t have more than ______ categories.
Ten
Twenty Five
Seven
Three
Column charts are useful for ______.
Showing data changes over a period of time.
Illustrating comparisons among items.
Both Showing data changes over a period of time and Illustrating comparisons among items.
None of the above.
Doughnut charts ______.
Contains more than one data series.
Comparable with a pie chart.
Both contains more than one data series and comparable with a pie chart.
None of the above.
The 2D graph using _______, _________ axes and in 3D graph ______ axis is also used
Category, value, vertical.
Horizontal, vertical, depth.
Category, value, series.
Horizontal, vertical, depth and Category, value, series, both.
Excel automatically redraws the chart ______.
If any change is made in the data.
If any change is made in the range data.
If any change is made in the data, and if any change is made in the range data, both.
None of the above
A ‘legend’ can be repositioned on the chart ______.
On the right side only.
On the left side only.
On the bottom of x-axis.
Anywhere
Which chart element details the data values and categories below the chart?
Data point
Data labels
Data marker
Data table
From what command tab is the font size for an axis in a chart changed?
Home
Insert
Format
Design
Which of these purposes does not pertain to charts?
Identifying trends
Selecting values
Recognising patterns
Making comparisons
What do you see if you move over the mouse over a chart object?
KeyTip
ScreenTip
ChartTip
ChartKey
Which group on the Chart Tools Format tab shows the name of the selected element?
Arrange Objects
Chart Objects
Choose Selection
Current Selection
ANSWER THE FOLLOWING QUESTIONS
Define charts.
Define graphs.
How are charts and graphs useful in business decisions?
Write down the usage column chart.
Write down the usage of a pie chart.
Write down the usage of a line chart.
Write down the purpose of a column chart.
Write down the purpose of a pie chart.
Write down the purpose of a line chart.
Describe about data series.
Describe about legend.
Describe about data labels.
Describe the use of Excel for the preparation of a chart.
Differentiate between pie charts, line charts and column charts respectively.
Described the steps to move a chart.
Described the steps to resizing a chart.
Described the steps to reposition a chart.
What does the percentage in the chart represent?
How is the percentage in the chart calculated by the software?
What are the differences between the Area, XY chart and doughnut?
What are the differences between 2-D Charts and 3-D Charts?
What is a pie chart?
what are percentage values means in pie chart?
Different types of charts which can be prepared using Excel?
A. Create a trend chart after filling data into the worksheet. (Population of India/State in Millions to be enter)
| Year | Male(1) | Female (2) | Total(3) | |||
| Literate | Illiterate | Literate | Illiterate | Literate | Illiterate | |
| 2001 | ||||||
| 2002 | ||||||
| 2003 | ||||||
| 2004 | ||||||
| 2005 | ||||||
| 2006 | ||||||
| 2007 | ||||||
| 2008 | ||||||
Note: Total Literate = Values of Male Literate + Values of Female Literate
Total Illiterate = Values of Male Illiterate + Values of Female Illiterate
B. Create a Pie chart to compare data from the above table for Total (column number 3).
C. Draw a trend chart for each male, female and total separately.
D. Draw a Column Chart for the above data for each (male, female and total) separately for Literate and Illiterate.
Prepare a Pie chart and a column chart for the 10 different plot areas: 5, 7, 8, 9, 8, 10, 4, 6, 7 and 3 hectares, respectively.
Draw a Pie chart for the following data on vehicles registered in the RTO department during 2007-08 in your city.
| Vehicle Type | Bus | Trucks | Auto Rixa | Cars | Two Wheelers | Heavy Vehicles |
| Number of Vehicles | 575 | 5889 | 12345 | 9765 | 23456 | 65 |
Draw a Column chart for the following data.
| Marks | 0-20 | 21-40 | 41-60 | 61-80 | 81-100 | Total |
| Number of Students | 113 | 180 | 350 | 232 | 125 | 1000 |
Solutions for 4: Graphs and Charts for Business Data
NCERT solutions for अकाऊंटन्सी कॉम्प्युटराइज्ड अकाउंटिंग सिस्टम [इंग्रजी] इयत्ता १२ chapter 4 - Graphs and Charts for Business Data
Shaalaa.com has the CBSE Mathematics अकाऊंटन्सी कॉम्प्युटराइज्ड अकाउंटिंग सिस्टम [इंग्रजी] इयत्ता १२ CBSE solutions in a manner that help students grasp basic concepts better and faster. The detailed, step-by-step solutions will help you understand the concepts better and clarify any confusion. NCERT solutions for Mathematics अकाऊंटन्सी कॉम्प्युटराइज्ड अकाउंटिंग सिस्टम [इंग्रजी] इयत्ता १२ CBSE 4 (Graphs and Charts for Business Data) include all questions with answers and detailed explanations. This will clear students' doubts about questions and improve their application skills while preparing for board exams.
Further, we at Shaalaa.com provide such solutions so students can prepare for written exams. NCERT textbook solutions can be a core help for self-study and provide excellent self-help guidance for students.
Concepts covered in अकाऊंटन्सी कॉम्प्युटराइज्ड अकाउंटिंग सिस्टम [इंग्रजी] इयत्ता १२ chapter 4 Graphs and Charts for Business Data are .
Using NCERT अकाऊंटन्सी कॉम्प्युटराइज्ड अकाउंटिंग सिस्टम [इंग्रजी] इयत्ता १२ solutions Graphs and Charts for Business Data exercise by students is an easy way to prepare for the exams, as they involve solutions arranged chapter-wise and also page-wise. The questions involved in NCERT Solutions are essential questions that can be asked in the final exam. Maximum CBSE अकाऊंटन्सी कॉम्प्युटराइज्ड अकाउंटिंग सिस्टम [इंग्रजी] इयत्ता १२ students prefer NCERT Textbook Solutions to score more in exams.
Get the free view of Chapter 4, Graphs and Charts for Business Data अकाऊंटन्सी कॉम्प्युटराइज्ड अकाउंटिंग सिस्टम [इंग्रजी] इयत्ता १२ additional questions for Mathematics अकाऊंटन्सी कॉम्प्युटराइज्ड अकाउंटिंग सिस्टम [इंग्रजी] इयत्ता १२ CBSE, and you can use Shaalaa.com to keep it handy for your exam preparation.
