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

4.  Think and answer.
                    a.  What is a cell reference in Excel?

                     ______________________________________________________________________________________
                     ______________________________________________________________________________________

                    b.  How do you enter a formula directly into a cell?

                     ______________________________________________________________________________________
                    c.  Write the purpose of the SUM function in Excel.

                     ______________________________________________________________________________________
                    d.  Summarise the use of the CONCATENATE function.

                     ______________________________________________________________________________________
                     ______________________________________________________________________________________

                    e.  How do you select a range of cells using the mouse in Excel?
                     ______________________________________________________________________________________

                     ______________________________________________________________________________________

                     ______________________________________________________________________________________

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

                    b.  Comparison Operators                              Reference Operators
                    ______________________________________                ______________________________________
                    ______________________________________                ______________________________________

                                                                                                21 st
                 6.  Competency-based/Application-based questions.                            Century   #Technology Literacy
                                                                                               Skills
                    a.   Adhyay entered a ten-digit number in Excel. He now wants to extract the last three digits of this
                      number. Which function should he use for this? Also write the syntax.
                    b.   Gaurav wants to compare  the values of two different columns. He wants to check
                      whether the values are equal or not. Which operator should he use? Give the symbol for
                      that operator.






                                                                                                   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.






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