Page 44 - Chinmaya_C6_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   Premium Edition-VI                                                                                                                                                                                Charts in Excel 2016  43
   39   40   41   42   43   44   45   46   47   48   49