Page 112 - TP_Modular_V2.1_Class7
P. 112

Project 3                                                                    21 st   #Critical Thinking
                                                                                             Century
                  Make the following table in Excel.                                           Skills  #Creativity




























                      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.






































                  110       Modular (Ver. 2.1)-VII
   107   108   109   110   111   112   113   114   115   116   117