Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 54 - 2620_Birla Open Mind C-6
P. 54

    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 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.

                      52  Premium Edition-VI

| 49 50 51 52 53 54 55 56 57 58 59 |