Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 28 - 2607_Trackpad_Pro_5.1_flipbook_C7
P. 28

    Let us understand this by taking an example of the SUM( ) function. Perform the following steps:

                                                           2  Click on Formulas tab.

                       3  Click on the
                       Insert Function
                       command.

                       1  Select an                                                                        4  Select SUM
                       empty cell to                                                                      in the Select a
                       hold the sum of                                                                    Function List.
                       the numbers.

                                                                                                           5  Click on the
                                                                                                          OK button.

                       6  Type the arguments in the number fields which are
                       the range of cells to find the sum of their contents.

                                   7  Click on OK button.

                          Tick ( ) if you know this.

                              A formula starts with an (=) sign.
                              Functions are predefined formulas that perform a series of operations on a specified range of values.

                                TEXT FUNCTIONS

                     Some text functions with their examples are given below:

                           Function                           Purpose                               Example

                                                                                           Input: =CONCATENATE
                      CONCATENATE            It joins together two or more different text   (“Track”, “pad”)
                      (text1, text2)         strings.
                                                                                           Output: Trackpad

                                                                                                     Functions in Excel  27

| 23 24 25 26 27 28 29 30 31 32 33 |