Page 30 - Trackpad_V5_Book 6
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 tabof 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.




                                                                                                    21 st
                                                      Self Reflection                            Century   #Initiative
                                                                                                   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?







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