Page 52 - modular4.0
P. 52

Chapter Profile

                                                                           3  Type =UPPER(B3) function in
                                                                           the cell  E3 to convert the first
                                                                           name into uppercase and press
                                                                           Enter key.

                  The first name appears in uppercase.

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



                  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 numbers  Input: =AVERAGE(12,3,6)
                   AVERAGE(range)
                                        in a 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

                  Let's use the statistical functions in Excel 2019. Perform the given steps to use the statistical functions:

                             1  Type the given
                            data in the Excel 2019
                            worksheet.



                                                                2  Type =MAX(C3:G3) function in the cell H3 to
                                                                find the maximum marks and press Enter key.

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

                                                                                           3  Type  =AVERAGE(C3:G3)
                                                                                          function in the cell J3 to find
                                                                                          the average of marks and
                                                                                          press Enter key.





                  When you press the Enter key, the average of marks appears in the cell J3. Using the AutoFill
                  feature, we can calculate the average of marks of each student.





                50   Modular (Ver. 4.0)-VII
   47   48   49   50   51   52   53   54   55   56   57