Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 15 - 2612 Digimind C6
P. 15

    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

                                                                                     Formulas and Functions in Excel 2021  13

| 10 11 12 13 14 15 16 17 18 19 20 |