Page 50 - TP_Plus_v4_Class6
P. 50

When you press the Enter key, the maximum marks appear in the cell G3, 89 in the given example. Using
               the AutoFill feature find the maximum marks of each student. Similarly, we can find the minimum marks
               by using the MIN() function.

               Date and Time Functions

               Date and Time functions are used to work on system's date and time.


                    Functions                           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

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

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

               You can use the date functions in Excel. To do so, type =TODAY()                          Date Function
               in the cell and press the Enter key from the keyboard.

               When you press the Enter key, the current date appears in the cell.

               We can also give the reference of a cell containing the date to
               the MONTH(), YEAR() and DAY() functions to get the month,
               year and day from a date respectively.
                                                                                           Using TODAY function



                                                               Hintbot





                        To use the the common functions like SUM, AVERAGE, MAX and MIN: click
                      on the down-arrow of the AutoSum command.
                        To use other functions: click on More Functions option.









                  48  Plus (Ver. 4.0)-VI
   45   46   47   48   49   50   51   52   53   54   55