Page 131 - Plus_V2.2_C6_Flipbook
P. 131
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 the total marks
https://www Subject Enrichment https://www
of a student and also calculate the percentage of the marks they
have obtained. Here is an example.
https://www https://www
D. Enter the following data in Excel: Subject Enrichment
(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.
Subject Enrichment
E. Enter the following data in Excel:
https://www https://www
Perform the following tasks:
(i) C2 =(A2*B2) (ii) C3 =(A5=B3) (iii) E5 =COUNT(A2:B5)
Project 129
https://www

