Page 44 - Trackpad_V2.1_Class6
P. 44
4. Think and answer.
a. Write any one advantage of a chart.
______________________________________________________________________________________
b. Define any two components of a chart.
______________________________________________________________________________________
______________________________________________________________________________________
c. What is a line chart? What type of data can be represented using a line chart?
______________________________________________________________________________________
______________________________________________________________________________________
d. How can we change the background of a chart we have created?
______________________________________________________________________________________
______________________________________________________________________________________
e. What is a doughnut chart, and how does it differ from a pie chart?
______________________________________________________________________________________
______________________________________________________________________________________
______________________________________________________________________________________
f. Write the steps to change the chart type.
______________________________________________________________________________________
______________________________________________________________________________________
______________________________________________________________________________________
21 st
5. Application-based questions. Century #Technology Literacy
Skills
a. Abhishek has entered the marks he obtained in Class V in different subjects in an Excel
Sheet. He now wishes to compare these with the marks he obtained in Class IV. Which
type of chart should he use for this purpose?
b. Shweta is a part of a group project. Now that the project is completed, she wishes to see how
much contribution was given by each member of the group. Which chart should she create
for this?
c. Anaya was studying the growth of a company’s profits over a period. She entered the data that was
available in Excel and now wishes to understand it more easily by displaying it in a way that shows
the magnitude of change over time. Which type of chart should she use for this?
42 Trackpad (V2.1)-VI Charts in Excel 2016 43

