Page 32 - Trackpad_V2.1_Class6
P. 32

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 errors occurs when the formula contains an invalid operation?
                         (i)  #VALUE!                                 (ii)  NUM!

                        (iii)  REF!                                  (iv)  #NAME?
                     d.  Which of the following functions finds the specified number of values from a given set of values?

                         (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( )

                  2.  Fill in the blanks using the words from the help box.

                                            cell reference, LEN, function, Label, equal to


                     a.  We cannot do mathematical calculations on __________.
                     b.  A formula must always begin with an/a __________ sign.

                     c.  __________ is used in a formula to denote a specific cell.
                     d.  A __________ is a predefined formula in Excel.

                     e.  The __________ function is used to get the length of the string.



                   30   Trackpad (V2.1)-VI
   27   28   29   30   31   32   33   34   35   36   37