Page 154 - Plus_V2.2_C7_Flipbook
P. 154
https://www
PROJECT
A. In Excel, create a tabular data of 5 of your friends' marks obtained in the previous exams
https://www https://www
and plot a graph for the average marks and the average percentage obtained for each of
them. Here is an example dataset.
Subject Enrichment
https://www https://www
Subject Enrichment
B. Make the following table in Excel.
• The formula for calculating average has been shown in the first cell.
https://www https://www
• 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.
152 Premium Edition-VII

