Page 105 - Computer - 6
P. 105

4.  The _____________ error occurs when the text in a formula is not recognised by Excel.

              5.  By default, Excel uses _____________ cell references when copying a formula from one cell to

                  another cell.

          C.   Write ‘T’ for True and ‘F’ for False statement.

              1.  All Formulas in Excel start with an equal (=) sign.                                        _______

              2.  The / operator has lower precedence than – operator in an Excel formula.                   _______

              3.  The error #NUM! occurs when the formula contains an invalid numeric value.                 _______

              4.  In absolute referencing, only one cell reference – row or column, is fixed.                _______

              5.  The COUNT( ) function is used to find the number of cells that contain numerical
                  values in a specified cell range.                                                          _______


          D.  Answer the following questions.

              1.  Write the different ways to enter a cell reference in a formula.
              2.  What is a function? Write any four functions with their uses in Excel.

              3.  Explain the three types of cell referencing in Excel with an example of each.

              4.  Describe any five errors that occur while using formulas in Excel.

              5.  What is the AutoSum feature? Name the functions available with the AutoSum feature in Excel
                  2019.


            Mind Stretching

            1.  Give the result of the following formulas and functions in Excel.                       Logical Thinking

                (a) = 9 ^ 2 + 10 – 4                                       = __________
                (b) = 3 * (5 + 4) – 11 + 13                                = __________

                (c) = 4 + 6^2 – 5                                          = __________

                (d) = PRODUCT (AVERAGE (54, 65, 78, 90, 45), 5)            = __________

                (e) = SUM (MAX (45, 23, 67, 54), MIN (73, 67, 42, 56))   = __________

            2.  Yamini has typed a formula in a cell in an Excel worksheet. Instead of getting the required answer,
                she got the result #####. Help her display the correct result of the formula.       Computational Skills

            3.  Ruchi has a list of numbers in cells A1 to A5 in an Excel worksheet. She wants to calculate 110% of
                each number. She types 1.1 in cell D2 and the formula =A4*C2 in cell B1. She copies the formula

                from cell B1 down to cell B5. But, she gets the result 0 in all cells except cell B1. Help her correct
                the formula to get desired result.                                                  Computational Skills



                                                                                                             103
   100   101   102   103   104   105   106   107   108   109   110