Page 51 - modular4.0
P. 51

Chapter Profile







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

                                                                              formula in cell D7.

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


                 Text Functions


                          Function                        Purpose                             Example
                                                                                 Input:   =CONCATENATE(“Touch”,
                                              It  joins  together  two  or more
                  CONCATENATE(text1, text2)                                      “pad”)
                                              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 the text string.                Output: Tou
                                              It returns the specified number    Input: =RIGHT(“Touch”,3)
                  RIGHT(text, num_chars)      of characters from the right side
                                              of the text string.                Output: uch
                                              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)
                                              upper case.                        Output: TOUCH
                                              It converts the text string into  Input: =LOWER(”Touch”)
                  LOWER(text)
                                              lower case.                        Output: touch

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

                                   1  Type the given
                                  data in the Excel 2019
                                  worksheet.




                                          2  Type  =CONCATENATE(B3,C3) function  in  the cell D3  to
                                          concatenate the first name and last name and press Enter key.

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









                                                                                              Formulas and Functions  49
   46   47   48   49   50   51   52   53   54   55   56