Page 44 - Trackpad_V1_Book 6_Flipbook
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 pie chart? What type of data can be represented using a pie chart?
___________________________________________________________________________________
___________________________________________________________________________________
d. How can we change the background of a chart we have created?
___________________________________________________________________________________
___________________________________________________________________________________
e. Explain the Line chart?
___________________________________________________________________________________
___________________________________________________________________________________
___________________________________________________________________________________
f. Write the steps to change the chart type.
___________________________________________________________________________________
___________________________________________________________________________________
___________________________________________________________________________________
5. Application based questions. Experiential Learning
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 (Version 1.0)-VI Charts in Excel 2010 43

