Page 29 - TP_V5.1_C7_fb
P. 29

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