Page 140 - iPlus_Ver_2.0_class_8
P. 140
PROJECT
#Problem Solving & Logical Reasoning
#Creativity & Innovativeness
A. Create a worksheet in Excel as shown below.
1. Find the name of the team which has played the most matches by using the MAX() function.
2. Find the number of matches lost by each team by using the subtraction formula.
3. Compare the performance of India and Pakistan by checking if India won more matches than
Pakistan.
4. Calculate the win percentage of each team.
#Coding & Computational Thinking
#Problem Solving & Logical Reasoning
B. Enter the following data in Excel:
Perform the following tasks:
1. C2 =(A2*B2)
2. C3 =(A5=B3)
3. E5 =COUNT(A2:B5)
138
iPlus (Ver. 2.0)-VIII

