Page 46 - Plus V4 with Adobe class 6
P. 46

To calculate the price
                  Type  the  given                                           of Pencils, type the
              1   data in the  Excel                                         =PRODUCT(B3:C3) function     2
                  worksheet.                                                 and press Enter key.





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



                To calculate the subtotal, type the             Calculate  the  Total  by
           3    =SUM(D3:D5) function and press              5   using the =SUM(D6:D7)
                Enter key from the keyboard.                    function.

        Text Functions

        Text functions are used to work on the characters entered as text.

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

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

                                   It returns the specified number of characters    Input: =RIGHT(“Touch”,3)
         Right(text, 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 upper case.     Output: TOUCH
                                                                                    Input: =LOWER(”Touch”)
         Lower(text)               It converts the text string into lower case.     Output: touch


        Let us use the Text functions by performing the following steps:






                                                                               Type =CONCATENATE(A3,B3)
              Type  the  given                                                 function to concatenate the
          1   data  in  the  Excel                                             first name and last name and   3
              worksheet.                                                       press Enter key.



        When you press the Enter key, first name and last name appear after concatenation.


            44  Plus (Ver. 4.0)-VI
   41   42   43   44   45   46   47   48   49   50   51