Kips IT Class 9 Chapter 14 Solutions USING CHARTS IN A SPREADSHEET Part-B

TextbookKips Information Technology Class 9
PartB
UnitUnit-4 Electronic Spreadsheet
Chapter14 Using Charts in a Spreadsheet
Other Chapters SolutionsKips IT Class 9 Solutions

Answer the Following Questions:

Define a Chart.

A chart is a graphical representation of data in a worksheet. It helps to provide a better understanding of large quantities of data. Charts make it easy to draw comparisons, see growth and relationship among the values, and trends in data. They provide an accurate analysis of information.

What is the use of inserting charts in a worksheet?

Inserting Charts in a worksheet provides a better understanding of large quantities of data and make it easy to draw comparisons, see growth and relationship among the values, and trends in data.

Which is the default chart type?

Column Chart is the default chart type of MS Excel.

Define the following:
a. Line Chart
b. Pie Chart
c. Bar Chart

a. Line Chart
It is in the form of lines and used to illustrate trends in data at equal intervals. It is quite similar to plotting a graph on a graph paper with its values on the X and Y axis. It is useful in emphasising continuity by showing change in data over time. It is generally used to compare a trend for a period of time.
b. Pie Chart
This chart displays data in the form of a circle that is divided into a series of segments. It shows the proportional size of individual items that makes up a data series to the sum of items. It always shows only one data series and is useful when you want to emphasise a significant element. This chart type works best with a small number of values.
c. Bar Chart
It illustrates the data comparison between individual items. It displays data in the form of long rectangular bars, that are placed horizontally in the chart area. In this type of chart, categories are represented on the vertical axis and values are represented on the horizontal axis.