Page 43 - trackpad v5.1 class 6 flipbook
P. 43
1. Tick ( ) the correct option.
a. Choose among the following, which chart type is used to display data in the form of long rectangular
rods?
(i) Column Chart (ii) Bar Chart
(iii) Line Chart (iv) Pie Chart
b. Find out the component of a chart that describes the main purpose and content.
(i) Legend (ii) Data Series
(iii) Title (iv) Gridlines
c. Name the tab you select for changing the type of an existing chart in Excel.
(i) Insert (ii) Design
(iii) Format (iv) Chart Design
d. What is the first step in creating a chart in Excel?
(i) Click on the Insert tab (ii) Select the data range
(iii) Choose the desired chart (iv) Click on the Chart Design tab
e. Tell the name of the chart, which is shaped like a circle divided into slices.
(i) Area Chart (ii) Doughnut Chart
(iii) Pie Chart (iv) Scatter Chart
2. Fill in the blanks using the words from the help box.
Shift, Line, X, Gridlines, Legend
a. The ______________ axis is also known as the category axis.
b. A ______________ chart displays continuous data at regular intervals.
c. The ______________ of a chart displays the symbols or colors used in the chart.
d. ______________ can be either horizontal or vertical lines that make it easier to read and understand
values in a chart.
e. To resize a chart proportionally, select the chart then press and hold the ______________ key while
dragging.
3. Answer in one or two words.
a. What is another name for the Y-axis in a chart? ___________
b. Which type of chart is also known as a frequency polygon? ___________
c. Which chart displays the relationship of parts to a whole? ___________
d. Which chart type is used to show correlations between two sets of values? ___________
e. What is the term for the rectangular area that contains the actual chart and
includes the plotted data? ___________
f. What command do you use to change the background of a chart in Excel? ___________
Charts in Excel 2021 41

