Page 156 - Trackpad_V4.0_c6_Flpbook
P. 156

d.  Add SmartArt such as lists to lay more emphasis on your points.

                    e.  After you are done, present it in front of your class.

              Excel                                                                    21 st  Century   #Technology Literacy
                                                                                           Skills
                                                                                               #Productivity & Accountability
              1.   Using Excel, prepare a calculator that can calculate the total marks of a student and also calculate the
                 percentage of the marks they have obtained. Here is an example.










                                                                                                     #Technology Literacy
                                                                                             21 st  Century
              2.  Create a worksheet as shown:                                                   Skills  #Critical Thinking




















                    a.   Find the name of the team which has played the most matches by using the MAX() function.

                    b.   Find the number of matches lost by each team by using the subtraction formula.

                    c.   Compare the performance of India and Pakistan by checking if India won more matches than Pakistan.

                    d.   Calculate the win percentage of each team.

              3.   Enter the following data in Excel:                                        21 st  Century   #Technology Literacy
                                                                                                 Skills
                                                                                                     #Critical Thinking



























                154     Premium Edition-VI
   151   152   153   154   155   156   157   158   159   160   161