Page 26 - TP_iPlus_V2.1_Class8
P. 26

4  To calculate
                                                                                                the tax, type the
                                                                                                =PRODUCT(D6,C7)
                                                                                                function in cell D7
                                                                                                and press the Enter
                                                                                                key.

                     5  To calculate the total bill, type the =SUM(D6:D7) function in cell D8
                    and press the Enter key.

                  Text Functions


                          Functions                      Purpose                              Example
                                                                              Input: =CONCATENATE(“Touch”, “pad”)
                   CONCATENATE(text1,  It joins together  two  or  more
                   text2)                    different text strings.          Output: Touchpad

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

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

                                             It returns the length  of the text   Input: =LEN(“Touch”)
                   LEN(text)
                                             string.                          Output: 5

                                             It converts the text string into   Input: =UPPER(“Touch”)
                   UPPER(text)
                                             uppercase.                       Output: TOUCH

                                             It converts the text string into   Input: =LOWER(”Touch”)
                   LOWER(text)
                                             lowercase.                       Output: touch

                  To use the text functions, follow the given steps:








                    1  Type the
                    following
                    data in
                    the Excel                                                       2  Type =CONCATENATE(A3,B3)
                                                                                   function to concatenate the First
                    worksheet.
                                                                                   Name and Last Name and press
                                                                                   the Enter key.





                    24
                         iPlus (Ver. 2.1)-VIII
   21   22   23   24   25   26   27   28   29   30   31