Page 31 - TP_Pro_V5.1_Class6
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