Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 30 - logicode 2609 C6
P. 30

    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)

                            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.

                       28   Premium Edition-VI

| 25 26 27 28 29 30 31 32 33 34 35 |