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

