Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 31 - 2607_Trackpad_Pro_5.1_flipbook_C7
P. 31

    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
                        #Div/0!                                                  Change the divisor to a non-zero value.
                                              operation.

                                              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.

                                                                                                           Life Skills & Values
                                                               Self Reflection

                        Your brother is preparing a list of snacks items with their price for his birthday party. He is manually
                                                               Self Reflection
                        calculating the total amount. Is there any function or formula that can help him calculate the price
                        easily and quickly? As a responsible person, you should always suggest such ideas to the people in
                        need of them.

                       30   Premium Edition-VII

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