Page 27 - iPro_trackGPT_V5_Class8
P. 27

To use the text functions, follow the given steps:



                            1  Type the
                           data in the Excel
                           worksheet.




                                                       2  Type =CONCATENATE(A3,B3) function to concatenate
                                                       the First Name and Last Name and press the Enter key.

                 When you press the Enter key, the first name and last name will be joined into one full name
                 using concatenation.












                                            3  Type =UPPER(A3) function in cell D3 to convert the First
                                           Name into uppercase and press the Enter key.

                 When you press the Enter key, the first name appears in uppercase.











                                            4  Type =LOWER(A3) function in cell E3 to convert the first
                                           name into lowercase and press the Enter key.

                 When you press the Enter key, the first name appears in lowercase.
                 Statistical Functions

                      Function                         Purpose                                Example

                                       It returns the largest value in the given  Input: =MAX(4,16,12,9)
                  MAX(range)
                                       range.                                     Output: 16
                                       It returns the smallest value in the given  Input: =MIN(4,16,12,9)
                  MIN(range)
                                       range.                                     Output: 4
                                       It returns the average  of the  given  Input: =AVERAGE(12,3,6)
                  AVERAGE(range)
                                       numbers in a range.                        Output: 7
                                       It returns the count of the number of  Input: =COUNT(4,8,12)
                  COUNT(range)
                                       values in the selected range.              Output: 3







                                                                             Spreadsheet—Functions and Charts    25
   22   23   24   25   26   27   28   29   30   31   32