Page 27 - Trackpad_V5_Book 6
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 empty
              cell to hold the sum
              of the numbers.



                                                                       4  Click on the
                                                                      OK button.


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














                          6  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   (“Touch”, “pad”)
              (text1, text2)        strings.
                                                                                   Output: Touchpad



                                                                            Formulas and Functions in Excel 2021  25
   22   23   24   25   26   27   28   29   30   31   32