Page 29 - trackpad v5.1 class 6 flipbook
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: 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: 21-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  27
   24   25   26   27   28   29   30   31   32   33   34