Page 51 - TP_Modular_V2.1_Class7
P. 51

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 2016. Perform the given steps to use the statistical functions:

                 Step 1  Type the given data in the Excel 2016 worksheet.
                 Step 2   Type  =MAX(C3:G3)  function
                         in the cell  H3  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 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.

                 Step 4  Type =AVERAGE(C3:G3) function in the cell J3 to find the average of marks.
                 Step 5  Press the Enter key from the keyboard.









                                                        Using AVERAGE function

                 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.











                                                      Calculating average of marks
                 Logical Functions


                       Function                          Purpose                                 Example

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






                                                                                     Formulas and Functions       49
   46   47   48   49   50   51   52   53   54   55   56