Page 30 - trackpad v5.1 class 6 flipbook
P. 30

For example, TODAY() function:







                                                                        Subject: Use of AutoSum Command

                                                                        To use the common functions like SUM, AVERAGE,
                                                                        MAX and MIN,  click on the down-arrow  under
                                                                        Formula tab of the AutoSum command.

                                  Type =TODAY()
                                  in the cell.

                  Press Enter key, the current date appears in the cell.


                  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
                    ####                                                     Increase the width of the column.
                                          display the number.

                                          Division by zero is an invalid     Change the divisor to a
                    #Div/0!
                                          operation.                         non-zero value.
                                          The formula contains an invalid    Check if the data type is the same in all
                    #VALUE!
                                          operation.                         the referred cells.

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

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

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


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






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










                   28   Pro (V5.1)-VI
   25   26   27   28   29   30   31   32   33   34   35