SOLUTIONS FOR CLASS 9 CHAPTER USING CHARTS IN SPREADSHEET

 

1. Define a chart

A chart is a graphical representation of data in a worksheet. Charts make it easy to draw comparisons and see growth and relationship among the values, and trends in data.

2. What is the use of inserting charts in a worksheet

Charts make it easy to draw comparisons and see growth and relationship among the values, and trends in data. They provide an accurate analysis of information. MS Excel offers a wide range of charts to interpret the data. These charts share some common features, which assist the users to comprehend the data logically.

3. Which is the default chart type?

Column chart or Bar-chart is the default chart type.

4. Define the following-

(a) Line chart - It is in the form of lines and is 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.

(b) Pie chart - This chart displays data in the form of a circle that is divided into a series of segments. 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. They can be displayed as 2D or 3D graphics.