Page 27 - iPlus_Ver_2.0_class_8
P. 27

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














                                                   3  Type =UPPER(A3) function 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 to convert the first
                                                           name into lowercase and press the Enter key.


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

                 Logical 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

                                       It checks whether the given condition is   Percentage = 80
                  IF(condition,        met, and returns value1 if the condition  Input:  =IF(Percentage  >=  50,
                  value1, value2)      evaluates to true,  and value2 if the  “Passed”, “Failed”)
                                       condition evaluates to false.              Output: Passed


                 Let us use the logical functions in Excel.








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