Page 25 - TP_Pluse_V2.2_Class_7
P. 25
4. Short answer type questions.
a. What are gridlines?
______________________________________________________________________________
b. Define legend.
______________________________________________________________________________
c. What is Bar chart?
______________________________________________________________________________
d. What is Area chart?
______________________________________________________________________________
5. 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.
______________________________________________________________________________
______________________________________________________________________________
______________________________________________________________________________
6. Competency-based/Application-based questions.
a. 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?
b. You’re presenting your class project on how different sports teams performed
throughout the year. Which types of charts in Excel will help you visualise and
compare the performance of each team more clearly?
teCh Zone
Let's soLve
21 st
Century #Critical Thinking
Solve the crossword using the clues. Skills
Down:
1. It helps us to represent data pictorially.
2. This contains the actual chart and its other components.
Charts in Excel 2016 23

