Page 154 - TP_Pluse_V2.2_Class_7
P. 154
https://www
PROJECT WORK
PROJECT
A. In Excel, create a tabular data of 5 of your friend’s marks
https://www 21 st #Communication https://www
obtained in the previous exams and plot a graph for the average Century #Technology Literacy
Skills
marks and the average percentage obtained for each of them.
Here is an example dataset.
https://www https://www
21 st
Century #Critical Thinking
B. Make the following table in Excel. Skills
https://www https://www
• 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.
• Create a pie-chart of the average runs scored by the players similar to this.
152 Plus (Ver. 2.2)-VII
https://www

