Page 146 - TP_iPlus_V2.1_Class8
P. 146

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)







                   144
                         iPlus (Ver. 2.1)-VIII
   141   142   143   144   145   146   147   148   149   150   151