Page 144 - Trackpad_ipro 4.1_Class8
P. 144
PROJECT WORK
#Problem Solving & Logical Reasoning
A. Create a worksheet in Excel as shown below: #Creativity & Innovativeness
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
B. Enter the following data in Excel: #Problem Solving & Logical Reasoning
Perform the following tasks:
1. C2 =(A2*B2)
2. C3 =(A5=B3)
3. E5 =COUNT(A2:B5)
142 iPro (Ver. 4.1)-VIII

