Page 33 - KEC Khaitan C6 Flipbook
P. 33

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!

                 2.  Write the Output of the following Excel Functions:

                    a.  =SUM(10, 20, 30)

                     ______________________________________________________________________________________
                    b.  =PRODUCT(5, 4, 3)

                     ______________________________________________________________________________________
                    c.  =POWER(2, 3)

                     ______________________________________________________________________________________



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