Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 17 - 2612 Digimind C6
P. 17

    For example, MAX () function:

                                                                                            2  Type =MAX(B3:F3)
                                                                                            function in the cell G3.

                                   1  Type this data.

                     Now press the Enter key and the maximum marks appear in cell G3. Similarly, we can find the
                     minimum marks by using the MIN() function.

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

                                                                                     Formulas and Functions in Excel 2021  15

| 12 13 14 15 16 17 18 19 20 21 22 |