Page 28 - iprime_V2.2_class8
P. 28

Step 5  Type =LOWER(A3) function in cell E3 to convert the first name into lowercase. Press the
                          Enter key.













                                                          Using LOWER Function
                  The first name appears in lowercase.
                  Statistical Functions


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

                  To use the logical functions in Excel, follow these steps:
                  Step 1  Type the following data in the Excel worksheet.

                  Step 2  Type =MAX(B3:F3) function in cell G3 to find the maximum marks.
                  Step 3  Press the Enter key.























                                                           Using MAX Function

                          When you press the Enter key, the maximum marks appear in cell G3. Using the AutoFill
                          feature, find the maximum marks of each student. Similarly, we can find the minimum
                          marks by using the MIN() function.



                  26     iPRIME (Ver. 2.2)–VIII
   23   24   25   26   27   28   29   30   31   32   33