Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 27 - logicode 2609 C6
P. 27

    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

                        d.  Which function will you use to find the highest value in a range of cells?
                            (i)  SUM                                    (ii)  AVERAGE
                           (iii)  MAX                                   (iv)  MIN

                        e.  Which of the following errors indicates division by zero?
                            (i)  #VALUE!                                (ii)  #NAME?
                           (iii)  #DIV/0!                               (iv)  #REF!

                                                                                     Formulas and Functions in Excel 2021  25

| 22 23 24 25 26 27 28 29 30 31 32 |