Page 37 - Digicode_AI_class_6
P. 37

REFRESH


                  Excel allows users to create custom formulas to perform calculations on their data.
                  A cell reference is a cell address that can be used in a formula to denote a specific cell.
                  The equal to sign (=) tells Excel that the succeeding characters constitute a formula.
                  A group of selected cells is called a range.
                  Excel also contains built-in formulas called functions that make it easy to perform common calculations
                 on data.




                                             TeCh Ready



            A.  Tick ( ) the correct option.

                1.  Which of the following cell references can be included in the relative reference?
                    (i)  A3                                          (ii)  A$1

                   (iii)  $A$4                                       (iv)  $D6
                2.  Which of the following function is used to calculate the average of a range of values?

                    (i)  AVERAGE                                     (ii)  AVG

                   (iii)  SUM                                        (iv)  None of these
                3.  What is a group of selected cells called?

                    (i)  Selection                                   (ii)  Cell range

                   (iii)  Combination                                (iv)  None of these
                4.  What does the NOW() function display?

                    (i)  Date                                        (ii)  Time

                   (iii)  Both (i) and (ii)                          (iv)  None of these
            B.  Fill in the blanks using the words given below.

                                       Functions   Equal to   Dollar ($)   Square root

                1.                    are predefined formulas in Excel.
                2.  Formulas in Excel begin with the                 sign.

                3.  The SQRT function returns the                  of the given number.

                4.   In mixed referencing, you can lock either a column or a row by preceding it with a
                   symbol.

            C.  State whether these statements are true or false.
                1.  Every formula begins with a + sign.
                2.  Combined reference is a type of cell reference.

                3.  A group of selected cells is called a function.



                                                                         Formulas and Functions in Excel  35
   32   33   34   35   36   37   38   39   40   41   42