Page 34 - trackpad v5.1 class 6 flipbook
P. 34

21 st   #Technology Literacy
                     LAB ACTIVITY                                                      Century
                                                                                        Skills  #Productivity & Accountability
                    Visit your computer lab and perform the following actions:

                    ▶  Enter the following data in Excel, then perform the tasks in the cells listed below.












                      a.   C2- =(A2*B2)                       b.  C3- =(A5=B3)
                      c.  C4- =(A2:A6)                        d.  E2- =AVERAGE (A2:A6)
                      e.  E3- =(D2&D4)                         f.  E4- =MID(D5, 4, 3)
                      g.  C5- =(A3<>B5)                       h.  C6- =(B6^2)
                      i.  E5- =MAX(A2:B6)                      j.  E6- =COUNT(A2:B5)





                                                                                      21 st
                           COding Zone       COding Zone    {}      =     COding Zone
                                                                                          #Productivity & Accountability
                                 {C ding z ne}
                                                                                    Century
                                                                                          #Critical Thinking
                                                                                      Skills
                                                                           </>
                      The following formulas have some typing errors. Correct them and then write the result.
                      a.  =’Good’”Morning”         b.  MIN(10,6,-2,0)       c.  =ADD(65+45)     d.  =RGHT(1256,2)





                        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.




















                   32   Pro (V5.1)-VI
   29   30   31   32   33   34   35   36   37   38   39