Page 116 - modular4.0
P. 116

Chapter Profile
                  Project 3                                                                       21 st   #Technology Literacy
                                                                                                Century
                  Make the following table in Excel.                                             Skills  #Critical Thinking

                      S. No.   Name of the Player        Match Played          Runs Scored       Average Scored

                        1     Virat Kohli                      210                 2685               =D2/C2
                        2     Rohit Sharma                     199                 2487


                        3     Shikhar Dhawan                   158                 3695
                        4     Krunal Pandya                    128                 1587

                        5     Rishabh Pant                      95                 659
                        6     Deepak Chahar                     39                 298
                        7     Shivam Dubey                      47                 749

                        8     K L Rahul                         88                 159
                        9     Sanju Samson                      88                 128

                        10    Shardul Thakur                   159                 296
                        11    Yuzvender Chahal                  93                 199


                     The formula for calculating average has been shown in the first cell.

                     Calculate averages for all the players using the formulas.

                     Calculate grand total of runs scored by all the players.
                     Sort the table in the increasing order of runs scored.

                     Sort the table in the decreasing order of the number of matches played.

                     Create a pie-chart of the average runs scored by the players similar to this.






































                114  Modular (Ver. 4.0)-VII
   111   112   113   114   115   116   117   118   119   120   121