Page 28 - iPlus_Ver_2.0_class_8
P. 28

To use the logical functions, follow the given steps:







                     1  Type the
                     following
                     data in
                     the Excel
                     worksheet.




                                                                          2  Type =MAX(B3:F3) function to find the
                                                                         maximum marks and press the Enter key.


                  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.














                                                                  3  Type =AVERAGE(B3:F3) function to find
                                                                 the average of marks and press the Enter key.


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















                  Date and Time Functions


                        Functions                          Purpose                               Example
                                                                                       Input: =TODAY()
                   TODAY()                It returns the current date.
                                                                                       Output: 7/23/2022
                                                                                       Input: =MONTH(TODAY())
                   MONTH(TODAY())         It returns the current month.
                                                                                       Output: 7



                    26
                         iPlus (Ver. 2.0)-VIII
   23   24   25   26   27   28   29   30   31   32   33