Page 132 - TP_Pluse_V2.2_Class_6
P. 132
https://www
(iv) Add SmartArt such as lists to lay more emphasis on your points.
(v) After you are done, present it in front of your class.
C. Using Excel, prepare a calculator that can calculate
https://www 21 st https://www
the total marks of a student and also calculate the Century #Productivity & Accountability
percentage of the marks they have obtained. Here is an Skills
example.
https://www https://www
21 st
D. Enter the following data in Excel: Century #Productivity & Accountability
Skills
(i) Find the name of the team which has played the most matches by using the MAX()
function.
(ii) Find the number of matches lost by each team by using the subtraction formula.
(iii) Compare the performance of India and Pakistan by checking if India won more matches
than Pakistan.
(iv) Calculate the win percentage of each team.
21 st
E. Enter the following data in Excel: Century #Productivity & Accountability
Skills
https://www https://www
Perform the following tasks:
(i) C2 =(A2*B2) (ii) C3 =(A5-B3) (iii) E5 =COUNT(A2:B5)
130 Plus (Ver. 2.2)-VI
https://www

