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

                    LEFT(text,            It returns the specified number of characters  Input: =LEFT(“Touch”,3)

                    num_chars)            from the left side of the text string.         Output: Tou

                    RIGHT(text,           It returns the specified number of characters  Input: =RIGHT(“Touch”,3)
                    num_chars)            from the right side of the text string.        Output: uch

                                                                                         Input: =LEN(“Touch”)
                    LEN(text)             It returns the length of the text string.
                                                                                         Output: 5
                                                                                         Input: =UPPER(“Touch”)
                    UPPER(text)           It converts the text string into uppercase.
                                                                                         Output: TOUCH
                                                                                         Input: =LOWER(”Touch”)
                    LOWER(text)           It converts the text string into lowercase.
                                                                                         Output: touch



                   26   Trackpad (Version 1.0)-VI
   23   24   25   26   27   28   29   30   31   32   33