Page 28 - Trackpad_V2.1_Class6
P. 28

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


                    LEFT(text,            It returns the specified number of characters  Input: =LEFT(“Track”,3)
                    num_chars)            from the left side of the text string.         Output: Tra


                    RIGHT(text,           It returns the specified number of characters  Input: =RIGHT(“Track”,3)
                    num_chars)            from the right side 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



                   26   Trackpad (V2.1)-VI
   23   24   25   26   27   28   29   30   31   32   33