Page 91 - ModularV1.1 _c7_flipbook
P. 91

Project 3                                                                             Inter-Disciplinary

                 Make the following table in Excel.



























                                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.







































                                                                                                   Project Work   89
   86   87   88   89   90   91   92   93   94   95   96