Page 33 - Trackpad_V5_Book 6
P. 33

21 st   #Communication
             GROUP DISCUSSION                                                               Century   #Social Interaction
                                                                                              Skills

               Divide the students into two groups and discuss the difference between Mathematical Function
               and Logical Function.





                                                                                          21 st
               LAB ACTIVITY                                                             Century   #Technology Literacy
                                                                                         Skills
              Visit your computer lab and perform the following actions:
              ▶  Open a  worksheet,  enter  your  first  name  in  the  A3  cell and  the  last  name  in  the  B3  cell. Now
                concatenate your first and last name using the text formula in cell E5.
              ▶  Enter the following data in Excel:












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




                     COding Zone       COding Zone    {}      =     COding Zone
                           {C ding z ne}
                                                                                     21 st
                                                                                        #Computational Thinking
                                                                                  Century
                                                                                        #Interdisciplinary
                                                                     </>
                                                                                    Skills
                1.  Calculate the given expression by following the order of precedence.
                   a.  =6*7+9–1             ______________       b.  =48/4^2          ______________
                2.  The following functions have some typing errors. Correct them and then write the result.
                   a.  =’Good’”Morning”     ______________       b.  MIN(10,6,-2,0)   ______________






                  CAREER HERE
            People who are experts in Microsoft Excel may pursue their careers as Data Analysts.



               FOR THE TEACHER
              1.  Help students create simple mathematical formulas to perform day-to-day calculations.
              2.  Demonstration of cell referencing and using in-built functions would be helpful.




                                                                            Formulas and Functions in Excel 2021  31
   28   29   30   31   32   33   34   35   36   37   38