Page 43 - Trackpad_V2.1_Class6
P. 43
1. Tick ( ) the correct option.
a. Which of the following is known as a vertical axis?
(i) Category axis (ii) Value axis
(iii) Both (i) & (ii) (iv) None of these
b. Which of the following displays the colour representation of each data series in the chart?
(i) Data series (ii) Horizontal axis
(iii) Legend (iv) Plot Area
c. Which chart is used to display data within a specified time period in the form of vertical bars?
(i) Column chart (ii) Bar chart
(iii) Line chart (iv) Pie Chart
d. Under which tab can we change the background of the chart?
(i) Home (ii) Formulas
(iii) Format (iv) Design
e. Which chart is also known as a frequency polygon?
(i) Line chart (ii) Bar chart
(iii) Histogram (iv) Pie chart
2. Fill in the blanks using the words from the help box.
Scatter, Column, Chart, Pie, Area
a. A __________ in Excel is the pictorial representation of data.
b. A __________ chart displays data series in the form of comparative charts.
c. A __________ chart is used to display data in the form of vertical bars within a specified time period.
d. An _________ chart displays the quantitative magnitude of the data change over the course of time.
e. A __________ chart is also known as XY scatter plot chart.
3. Write 'T' for true and 'F' for false.
a. Data representation using charts is quite inefficient.
b. The Y-axis of a chart is also known as the category axis.
c. The chart area includes all objects and elements in a chart.
d. A doughnut chart consists of more than one data series.
e. We cannot create a bar chart in Excel.
40 Trackpad (V2.1)-VI Charts in Excel 2016 41

