Page 27 - 2403_Trackpad_V5.1_C6_Fb
P. 27

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.  Competency-based/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?

                     ______________________________________________________________________________________





 24  Premium Edition-VI                                                                        Charts in Excel 2021  25
   22   23   24   25   26   27   28   29   30   31   32