Page 29 - Trackpad_V5_Book 6
P. 29

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: 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 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  27
   24   25   26   27   28   29   30   31   32   33   34