Page 43 - Trackpad_V1_Book 6_Flipbook
P. 43
1. Tick ( ) the correct option.
a. Which of the following is known as the 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. Which of the following tabs is used to change the chart background?
(i) Home (ii) Formulas
(iii) Format (iv) Design
e. What is an effective way to display data in a pictorial form?
(i) Picture (ii) Chart
(iii) Table (iv) Graphics
2. Fill in the blanks using the words from the help box.
Scatter, Column, Bar, Pie, Area
a. __________ chart displays the data in the form of vertical bars.
b. __________ chart displays data series in the form of comparative charts.
c. __________ chart is used to compare individual items.
d. __________ chart displays the quantitative magnitude of the data change over the time change.
e. __________ chart is also known as XY scatter plot charts.
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. Scatter chart is also known as XY scatter plot chart.
e. We cannot create Bar chart in Excel.
40 Trackpad (Version 1.0)-VI Charts in Excel 2010 41

