Page 30 - Trackpad_V1_Book 6_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/2019
                                                                                         Input: =MONTH(TODAY())
                    MONTH(TODAY())        It returns the current month.
                                                                                         Output: 7
                                                                                         Input: =YEAR(TODAY())
                    YEAR(TODAY())         It returns the current year.
                                                                                         Output: 2019

                                                                                         Input: =DAY(TODAY())
                    DAY(TODAY())          It returns the current day.
                                                                                         Output: 23

                                          It  returns the  current system  date  and  Input: =NOW()
                    NOW()
                                          time.                                          Output: 21-05-2020 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 of the AutoSum command.

                                            Type =TODAY()
                                            in the cell.
                  Press Enter key, the current date appears in the cell.



                   28   Trackpad (Version 1.0)-VI
   25   26   27   28   29   30   31   32   33   34   35