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
   126   127   128   129   130   131   132   133   134   135   136