Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 31 - 2615_KEC
P. 31

    21 st   #Initiative
                                                             Self Reflection                Century   #Leadership & Responsibility
                                                                                             Skills
                      Your mother has been preparing a list of grocery items with their price. She has been manually
                                                             Self Reflection
                      calculating the total amount. Is there any function or formula that can help her make her task
                      easier? Do you think you should be helping people whenever you see an opportunity?

                           Hashtag

                         #Operator: An operator is a symbol that is used to perform calculation
                         #Function: A predefined formula in Excel

                           REVISIT

                       ▶  Any text entered in Excel is called a label.
                       ▶  Any numeric data entered in Excel is called a value.
                       ▶  To perform mathematical calculations, a formula is entered in a cell.
                       ▶  A function is a predefined formula in Excel.
                       ▶  Operators are the symbols that are used to perform calculations.
                       ▶  A group of selected cells is called a cell range.
                       ▶  A cell reference is a cell address that can be used in a formula to denote a specific cell.

                     1.  Tick ( ) the correct option.

                        a.  Which of the following is considered a label in Excel?
                            (i)  123                                    (ii)  A1+B2
                           (iii)  Name                                  (iv)  45.67

                        b.  Which symbol is used to start a formula in Excel?
                            (i)  $                                      (ii)  @
                           (iii)  #                                     (iv)  =

                        c.  What type of operator is the colon (:) in Excel?
                            (i)  Arithmetic                             (ii)  Comparison
                           (iii)  Reference                             (iv)  Logical

                                                                                     Formulas and Functions in Excel 2021  29

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