Page 123 - 2617_JSSPS_C-6
P. 123
Practical Assessment
Excel 21 st Century #Technology Literacy
1. Make the following table in Excel. Skills #Productivity & Accountability
a. The formula for calculating average has been shown in the first cell.
b. Calculate averages for all the players using the formulas.
c. Calculate grand total of runs scored by all the players.
d. Create a pie-chart of the average runs scored by the players similar to this.
2. Using Excel, prepare a calculator that can calculate the total marks of a student and also calculate the
percentage of the marks they have obtained. Here is an example.
Practical Assessment 121
