Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 30 - 2615_KEC
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   Premium Edition-VI

| 25 26 27 28 29 30 31 32 33 34 35 |