Page 31 - KEC Khaitan C6 Flipbook
P. 31

1.   Which function calculates the maximum value from a given set of
                                             values?

                                             _____________________________________________________________
                         uiz   Bee        2.  Which operator has the highest order of precedence?

                                             _____________________________________________________________



                 DATE AND TIME FUNCTIONS
                 Some date and time functions with their examples are given below.




                        Function                           Purpose                               Example


                                                                                        Input: =TODAY()
                  TODAY()                It returns the current date.
                                                                                        Output: 23-07-2024

                                                                                        Input: =MONTH(TODAY())
                  MONTH(TODAY())         It returns the current month.
                                                                                        Output: 7
                                                                                        Input: =YEAR(TODAY())
                  YEAR(TODAY())          It returns the current year.
                                                                                        Output: 2024

                                                                                        Input: =DAY(TODAY())
                  DAY(TODAY())           It returns the current day.
                                                                                        Output: 23
                                                                                        Input: =NOW()
                  NOW()                  It returns the current system date and time.
                                                                                        Output: 21-07-2024 11:24

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

                 For example, TODAY() function:







                                                                      Subject: Use of AutoSum Command

                                                                      To use the common functions like SUM, AVERAGE,
                                                                      MAX and MIN,  click on the down-arrow  under
                                                                      Formula tab of the AutoSum command.
                                Type =TODAY()
                                in the cell.

                 Press Enter key, the current date appears in the cell.





                                                                                 Formulas and Functions in Excel 2021  29
   26   27   28   29   30   31   32   33   34   35   36