Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 23 - logicode 2609 C6
P. 23

    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  21

| 18 19 20 21 22 23 24 25 26 27 28 |