Page 32 - Chinmaya_C6_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 are 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 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( )
                  2.  Fill in the blanks using the words from the help box.


                                            Cell reference, LEN, function, Label, equal to


                     a.  We don't perform mathematical calculations on __________.
                     b.  A formula must always begin with an/a __________ sign.








                   30   Premium Edition-VI
   27   28   29   30   31   32   33   34   35   36   37