Page 30 - Chinmaya_C6_flipbook
P. 30

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: 7/23/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

                                          It  returns the  current system  date  and  Input: =NOW()
                    NOW()
                                          time.                                          Output: 7/23/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.

                  COMMON ERRORS IN FUNCTIONS
                   28
                        Premium Edition-VI
   25   26   27   28   29   30   31   32   33   34   35