Page 35 - KEC Khaitan C6 Flipbook
P. 35

5.  Differentiate between the following:
                    a.  Relative Cell Referencing                         Absolute Cell Referencing
                    ______________________________________                ______________________________________
                    ______________________________________                ______________________________________

                    b.  Comparison Operators                              Reference Operators
                    ______________________________________                ______________________________________
                    ______________________________________                ______________________________________







                                                                                          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)



                    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  33
   30   31   32   33   34   35   36   37   38   39   40