Page 27 - TP_iPlus_V2.1_Class8
P. 27

When you press the Enter key, the first name and last name appear after 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


                      Functions                        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

                                                                                  Input: =COUNT(4,8,12)
                                       It returns the count of the number of      Output: 3
                  COUNT(range)
                                       values in the selected range.






                                   If Excel was a magical library, how would you sort books and filter books you
                                   had read?






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