Page 27 - TP_Pro_V5.1_Class6
P. 27

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  25
   22   23   24   25   26   27   28   29   30   31   32