Page 35 - Digicode_AI_class_6
P. 35

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(date)            It returns the month of the given date.
                                                                                 Output: 7

                                                                                 Input: =YEAR(TODAY())
             YEAR(date)             It returns the year of the given date.
                                                                                 Output: 2022

                                                                                 Input: =DAY(TODAY())
             DAY(date)              It returns the day of the given date.
                                                                                 Output: 23


                                    It returns the current system date and       Input: = NOW()
             NOW()
                                    time.                                        Output: 21-05-2022 11:24

                                                                                 Input: = HOUR(NOW())
             HOUR(time)             It returns the hour from the given time.
                                                                                 Output: 11

                                    It returns the minutes from the given        Input: = MINUTE(NOW())
             MINUTE(time)
                                    time.                                        Output: 24





                                                                         Formulas and Functions in Excel  33
   30   31   32   33   34   35   36   37   38   39   40