Page 29 - KEC Khaitan C6 Flipbook
P. 29

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

                  LEFT(text,             It returns the specified number of characters   Input: =LEFT("Track",3)
                  num_chars)             from the start of the text string.             Output: Tra

                  RIGHT(text,            It returns the specified number of characters   Input: =RIGHT("Track",3)
                  num_chars)             from the end of the text string.               Output: ack

                                                                                        Input: =LEN("Track")
                  LEN(text)              It returns the length of the text string.
                                                                                        Output: 5

                                                                                        Input: =UPPER("Track")
                  UPPER(text)            It converts the text string into uppercase.
                                                                                        Output: TRACK
                                                                                        Input: =LOWER("Track")
                  LOWER(text)            It converts the text string into lowercase.
                                                                                        Output: track










                                                                                 Formulas and Functions in Excel 2021  27
   24   25   26   27   28   29   30   31   32   33   34