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

