Page 31 - Trackpad_V2.1_Class6
P. 31

COMMON ERRORS IN FUNCTIONS
                 We may get an error while performing calculations using functions. Some common errors are:




                      Error                         Meaning                             Troubleshooting Tip



                                   The column is not wide enough to display
                  ####                                                          Increase the width of the column.
                                   the number.

                                                                                Change the divisor to a non-zero
                  #Div/0!          Division by zero is an invalid operation.
                                                                                value.

                                                                                Check if the data type is the
                  #VALUE!          The formula contains an invalid operation.
                                                                                same in all the referred cells.

                                                                                Check if the data is entered in the
                  #N/A             Data is not available.
                                                                                cell.


                                   The function name  is  not  recognised  by  Check  and correct  the  function
                  #NAME?
                                   Excel.                                       name.

                  #REF!            The cell reference is not valid.             Check and correct the cell ranges.

                                                                                Ensure there are no special
                                   The  formula or function  contains  invalid
                  #NUM!                                                         symbols such as $ or % being
                                   numeric values.
                                                                                used with the number.




                                     Envision your favourite tech personality as a Gizmo Gadget. How would you paint
                                     their portrait in Excel?




                                                                                           21 st
                                                          Self Reflection                Century   #Technology Literacy
                                                                                          Skills
                   Your mother has been preparing a list of grocery items with their price. She has been manually
                                                          Self Reflection
                   calculating the total amount. Is there any function or formula that can help her make her task
                   easier? Do you think you should be helping people whenever you see an opportunity?






                        Hashtag

                      #Operator: An operator is a symbol that is used to perform calculations

                      #Function: A predefined formula in Excel




                                                                                 Formulas and Functions in Excel 2016  29
   26   27   28   29   30   31   32   33   34   35   36