Page 25 - Plus_V2.2_C7_Flipbook
P. 25
4. Match the columns.
Column A Column B
a. Area chart (i) Trends over a period of time
b. Pie chart (ii) Quantitative magnitude of data
c. XY Scatter Plot Chart (iii) Sector showing relative size of each other
d. Line chart (iv) Correlation between two sets of values
5. Short answer type questions.
a. What is a chart? Explain briefly.
______________________________________________________________________________
b. Define legend.
______________________________________________________________________________
c. What is Bar chart?
______________________________________________________________________________
d. What is Area chart?
______________________________________________________________________________
6. Long answer type questions.
a. What are the differences between line chart and XY scatter chart?
b. Explain any 5 components of a chart.
c. Write the steps to change the chart type.
fun Zone
Let's soLve Experiential Learning
1. Application based question.
Suman wants to present the information in the form of a chart. She has a data of single series
and the graph must show relative circular size of each value. Which chart type must she use?
2. Solve the crossword using the clues. Critical Thinking
Down:
1. It helps us to represent data pictorially.
2. This contains the actual chart and its other components.
Charts in Excel 2016 23

