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
   39   40   41   42   43   44   45   46   47   48   49