Chapter - 7 

Charts In Excel 

Exercises :

1. Fill in the blanks.

a. A ........................ is known as a chart in Microsoft Excel.

figure | diagram | graph

b. The area that encloses all the objects of the chart is the ............................... 

axis area | chart area | plot area

C. A group of related data in a chart is called .........................................

data series | data label | title

d. You can use a chart ................................. to change the colour and format of your chart.

layout | style | design

e. Chart Tools has ............................... chart context tabs.

three | four | five

2. Write T for true and F for false,

a. The x-axis is also called the category axis.

b. The chart changes automatically to reflect the changed data. 

c. You must include row and column headings 
if you want them displayed as labels in the chart.

d. The buttons in the Axes group control both the axes and gridlines.

e. By default, titles are added when you create a basic chart.

3. Finish the sentences.

 a. Various kinds of charts available in Excel are .................................................

b.  Chart Tools are....eign layout and format..........................................................

c. Legend is .....................................................................

d. The x-axis is ..............................................................

e. The y-axis is ..............................................................

4. Give short answers.

a. How is a chart useful?
Answer: 

b. What are gridlines?
Answer :

c. What are chart area and plot area?
Answer :

d. What happens to a chart if you change the data in it?
Answer :

e. How can you change the type of the chart you have created? 
Answer :

5. Put the steps for the following actions in the correct order.

a. To create a chart

     From the list of column chart sub-types, click your option.

      Select the data to chart.

       From the Insert tab, on the Chart group, click Column.

b. To display the Primary Horizontal Axis,

         From the Layout tab, on the Axes group, click the Axes button
        Choose Primary Horizontal Axis then Show Left to Right Axis.
        Click your chart.

   




Type by _ Pinku moni bora