NIOS Class 12 Accountancy Chapter 37 Graphs and Charts

NIOS Class 12 Accountancy Chapter 37 Graphs and Charts Solutions English Medium As Per New Syllabus. to each chapter is provided in the list so that you can easily browse throughout different chapters NIOS Class 12 Accountancy Chapter 37 Graphs and Charts Notes and select need one. NIOS Class 12 Accountancy Chapter 37 Graphs and Charts Question Answers Download PDF. NIOS Study Material of Class 12 Accountancy Paper Code: 320.

NIOS Class 12 Accountancy Chapter 37 Graphs and Charts

Also, you can read the NIOS book online in these sections Solutions by Expert Teachers as per National Institute of Open Schooling (NIOS) Book guidelines. These solutions are part of NIOS All Subject Solutions. Here we have given NIOS Class 12 Accountancy Solutions English Medium, NIOS Senior Secondary Course Accountancy Notes in English Medium for All Chapter, You can practice these here.

Graphs and Charts

Chapter: 37

Module – 7: Application of Computers in Financial Accounting

INTEXT QUESTIONS 37.1

Fill in the blanks :

(i) Graphs and Charts are ______________ representation of data.

Ans: Pictorial.

(ii) Graphs and charts have at least ______________ dimensional relationship.

Ans: Two.

(iii) X axis is usually ______________ while Y axis is ______________.

Ans: Horizontal, Vertical.

(iv) To view the charts available, we have to click the ______________ tab on the ribbon.

Ans: Insert.

Intext Questions 37.2

Fill in the blanks with suitable word/words:

(i) Plot area, X-axis, Y-axis, data, titles, labels, legends and gridlines are known as ______________ of a chart.

Ans: Elements.

(ii) To use a texture fill, we have to click ______________.

Ans: Texture.

(iii) A chart can be changed to another type of chart to get different look and ______________.

Ans: Purpose.

(iv) In Excel software, Pie chart cannot plot more than ______________ categories.

Ans: Seven.

TERMINAL EXERCISE

1. Define charts, graphs and how they are useful in business decisions?

Ans: Charts and graphs are pictorial representations of data which show relationships between different variables. A graph generally has two axes, X-axis (horizontal) and Y-axis (vertical), and helps in presenting data visually. Charts and graphs make it easier to understand large amounts of data quickly and clearly.

They are very useful in business decisions as they help in analysing trends, comparisons and relationships among different variables. They simplify complex data and present it in an understandable form, which helps management in planning, forecasting and decision-making. They also help in presenting data effectively, exploring relationships and convincing others through visual representation.

2. Write down the usage and purpose of column chart, pie chart and line chart.

Ans: (i) Column Chart: It is used to compare different categories of data using vertical bars. It is useful for comparing values at different time intervals or among different items.

(ii) Pie Chart: It is used to show the proportion or percentage of different parts to the whole. It represents data in the form of slices of a circle.

(iii) Line Chart: It is used to show trends over a period of time. It connects data points with lines and helps in analysing changes over time.

3. Describe about data series, legend, and data labels?

Ans: (i) Data Series: It is a group of related data points plotted in a chart. Each series is represented by a unique colour or pattern.

(ii) Legend: It is used to identify different data series or categories in a chart. It acts as a key to understand the chart.

(iii) Data Labels: These provide additional information about each data point, such as value or percentage, making the chart easier to understand.

4. Describe use of Excel for preparation of chart.

Ans: Excel is widely used for preparing charts to represent data graphically. The procedure is as follows:

(i) Select the data range from worksheet.

(ii) Click on the Insert tab on the Ribbon.

(iii) Choose the required chart type such as column, line or pie chart.

(iv) The chart is created automatically.

(v) The chart can be modified using Chart Tools (Design, Layout, Format).

(vi) Titles, labels, legend and other elements can be added or modified.

(vii) The chart can be moved, resized and formatted as per requirement.

5. Differentiate between pie charts, line charts and column charts respectively?

Ans: 

Basis	Pie Chart	Line Chart	Column Chart
(i) Purpose	Shows proportion of parts to whole	Shows trends over time	Compares different categories
(ii) Representation	Circle divided into slices	Points connected by lines	Vertical bars
(iii) Use	Percentage distribution	Trend analysis	Comparison of values
(iv) Data Type	Single data series	Continuous data	Discrete data

6. Described the steps to move, resizing and reposition a chart.

Ans: (i) To move a chart, click on the chart and drag it to the desired location.

(ii) Alternatively, use the “Move Chart” option from Design tab.

(iii) To resize, select the chart and drag the corners or edges using mouse.

(iv) The cursor changes to a double-headed arrow while resizing.

(v) The chart can be repositioned anywhere in the worksheet or moved to a new sheet.

7. What does percentage in chart represent and how it being calculated by the software?

Ans: Percentage in a chart represents the proportion of each data value to the total value. It shows how much each part contributes to the whole.

The software calculates percentage automatically by dividing each data value by the total of all values and multiplying by 100. This helps in showing relative importance of each data item in the chart.

8. What are the differences between:

(a) Area, XY chart and doughnut.

Ans: 

Basis	Area Chart	XY Chart (Scatter)	Doughnut Chart
(i) Purpose	Shows trend with filled area	Shows relationship between variables	Shows parts of whole
(ii) Representation	Filled area under line	Points plotted on X-Y axis	Circular ring
(iii) Use	Emphasises magnitude	Scientific data analysis	Multiple data series

(b) 2-D Charts and 3-D Charts.

Ans: 

Basis	2-D Charts	3-D Charts
(i) Dimensions	Two dimensional	Three dimensional
(ii) Axes	X and Y axis	X, Y and Z axis
(iii) Appearance	Simple and flat	More attractive and realistic
(iv) Use	Clear representation	Visual appeal

9. What is pie chart and what are percentage values means in pie chart?

Ans: A pie chart is a circular chart divided into slices to represent the proportion of different components of a whole. Each slice represents a part of total data.

The percentage values in a pie chart indicate the share of each component in relation to the total. These percentages are calculated by dividing individual values by total values and multiplying by 100.

10. Explain different types of charts which can be prepared using Excel?

Ans: Excel provides various types of charts for graphical representation of data:

(i) Column Chart – Used for comparison of data.

(ii) Line Chart – Used for showing trends over time.

(iii) Pie Chart – Used for showing percentage distribution.

(iv) Bar Chart – Similar to column chart but uses horizontal bars.

(v) Area Chart – Shows trends with filled areas.

(vi) Scatter (XY) Chart – Shows relationship between variables.

(vii) Doughnut Chart – Shows multiple data series in circular form.

Multiple Choice Questions

1. To change the location of a chart, right-click the chart and select:

(a) Chart Type.

(b) Source Data.

(c) Chart Options.

(d) Move here.

Ans: (d) Move here.

2. The Ribbon allows us to:

(a) Create either an embedded chart or a chart sheet chart.

(b) Create only an embedded chart.

(c) Create only a chart sheet chart.

(d) Change the data values used to create the chart.

Ans: (d) Change the data values used to create the chart.

3. Once we have created a chart we may change _____:

(a) the formatting for text like titles and data labels.

(b) only by going back through the ribbon.

(c) everything about the chart.

(d) the data series patterns only.

Ans: (a) The formatting for text like titles and data labels.

4. In Excel the chart tools provides three different options ______, ________ and

_______ for formatting:

(a) Layout, Format, Data Marker.

(b) Design, Layout, Format.

(c) Chart Layouts, Chart Style, Label.

(d) Format, Layout, Label.

Ans: (b) Design, Layout, Format.

5. Pie chart don’t have more than ________ categories:

(a) Ten.

(b) Twenty Five.

(c) Seven.

(d) Three.

Ans: (c) Seven.