Page 32 - Trackpad_V1_Book 6_Flipbook
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 error occurred when the formula is not recognised by Excel?

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








                   30   Trackpad (Version 1.0)-VI
   27   28   29   30   31   32   33   34   35   36   37