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