Page 35 - Computer Genius Class 06
P. 35

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

                 When you press the Enter key, the average of the marks appears in cell I3.  sing the AutoFill
                  eature   e can calculate the a erage o  the mar s o  each student.




















                 Date and Time Functions

                       Functions                          Purpose                                Example
                                                                                      I nput:  = TO D A Y ( )
                 TO D A Y ( )           It returns the current date.
                                                                                      O utput:  7 / 2 3 / 2 02 2

                                                                                      I nput:  = M O N TH ( TO D A Y ( ) )
                 M O N TH ( date)       It returns the month of the given date.
                                                                                      O utput:  7


                                                                                      Input: =YEAR(TODAY())
                 YEAR(date)              t returns the year o  the gi en date.
                                                                                      Output: 2022

                                                                                      Input: =DAY(TODAY())
                 DAY(date)               t returns the day o  the gi en date.
                                                                                      Output: 23

                                         It returns the current system date and       Input: = NOW()
                 NOW()
                                         time.                                        Output: 21    2 22 11 2


                                                                                      Input:
                      time                t returns the hour  rom the gi en 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