Page 132 - TP_Pluse_V2.2_Class_6
P. 132

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
          https://www                                                                     21 st                           https://www
                        the total  marks  of a  student  and  also  calculate  the      Century   #Productivity & Accountability
                        percentage of the marks they have obtained. Here is an            Skills
                        example.






         https://www                                                                                                     https://www



                                                                                          21 st
                     D.  Enter the following data in Excel:                             Century   #Productivity & Accountability
                                                                                          Skills















                        (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.

                                                                                           21 st
                     E.   Enter the following data in Excel:                            Century   #Productivity & Accountability
                                                                                          Skills




         https://www                                                                                                     https://www







                             Perform the following tasks:
                             (i) C2   =(A2*B2)                  (ii) C3   =(A5-B3)          (iii) E5   =COUNT(A2:B5)



                  130   Plus (Ver. 2.2)-VI
                          https://www
   127   128   129   130   131   132   133   134   135   136   137