Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 23 - 2612 Digimind C6
P. 23

    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.

                             COding Zone       COding Zone    {}      =      COding Zone
                                    {C ding z ne}
                                                                                            #Productivity & Accountability
                                                                                         21 st
                                                                                       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.

                                                                                     Formulas and Functions in Excel 2021  21

| 18 19 20 21 22 23 24 25 26 27 28 |