Page 50 - TP_Modular_V2.1_Class7
P. 50

Function                       Purpose                              Example

                                             It returns the specified number     Input: =RIGHT(“Touch”,3)
                   RIGHT(text, num_          of characters from the right side
                   chars)                                                        Output: uch
                                             of 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)
                                             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:

                  Step 1   Type  the  given data  in the  Excel 2016
                           worksheet.
                  Step 2   Type  =CONCATENATE(B3,C3) function in
                           the  cell  D3  to  concatenate  the  first  name
                           and last name.
                  Step 3  Press the Enter key from the keyboard.                    Using CONCATENATE function

                  When you press the Enter key, first name and last name appears after concatenation.
                  Step 4   Type =UPPER(B3) function in the cell E3 to convert the first name into uppercase. After
                           typing the function, press the Enter key from the keyboard.










                                                           Using UPPER function
                  The first name appears in uppercase.

                  Step 5   Type =LOWER(B3) function in the cell F3 to convert the first name into lowercase. After
                           typing the function, press the Enter key from the keyboard.









                                                          Using LOWER function

                  Statistical Functions

                        Function                          Purpose                                 Example
                                        It returns the largest value in the given  Input: =MAX(4,16,12,9)
                   MAX(range)
                                        range.                                         Output: 16




                   48       Modular (Ver. 2.1)-VII
   45   46   47   48   49   50   51   52   53   54   55