Page 26 - iPlus_Ver_2.0_class_8
P. 26

4  Calculate the
                                                                                                  Tax by using the
                                                                                                  =(D6*7)/100
                                                                                                  formula.




                                 5  Calculate the Total by using the =SUM(D6:D7) function.

                  Text Functions


                          Functions                      Purpose                              Example

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


                                             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)
                    worksheet.                                                     function to concatenate the First
                                                                                   Name and Last Name and press
                                                                                   the Enter key.





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