Class 7

Ch 7 :  Creating Charts in MS Excel

Exercise :

I.                   Fill in the blanks :

1.     Data table

2.     Value

3.     Line

4.     Chart Title

5.     Layout

II.                State True or False :

1.     False

2.     False

3.     True

4.     True

5.     True

III.             Answer the questions :

1.     A chart is a graphic representation of data in the worksheet. It increases the readability and understandability  of data. A chart can also be used to compare a series of data over different time spans.

The five components of a chart are: data series, chart

 

title, plot area, gridlines and data labels.

2. The five types of charts are bar chart, pie chart, line chart, doughnut chart, and column chart.

5.  The different options available in layout tab are Format  

     selection, Picture, Shapes, Text box, Chart title, Axis

     titles, Legend, Data labels, Data table, Axes and

     Gridlines.