Page 31 - Trackpad_V5_Book 6
P. 31

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 left-aligned by default?

                   (i)  Values                                  (ii)  Labels
                  (iii)  Formulas                              (iv)  None of these

               b.  Which of the following is an arithmetic operator?

                   (i)  ^                                       (ii)  =
                  (iii)  :                                     (iv)  <>
               c.  Which of the following error occurs when the formula is not recognised by Excel?

                   (i)  #VALUE!                                 (ii)  NUM!

                  (iii)  REF!                                  (iv)  #NAME?
               d.  Which of the following functions returns the count of the number of values in the selected range?

                   (i)  COUNT ( )                               (ii)  SUM ( )
                  (iii)  MAX ( )                               (iv)  Both (i) & (ii)

               e.  Which function returns the square root of the given number?
                   (i)  MOD( )                                  (ii)  INT( )

                  (iii)  POWER( )                              (iv)  SQRT( )





                                                                            Formulas and Functions in Excel 2021  29
   26   27   28   29   30   31   32   33   34   35   36