Page 46 - TP_Pluse_V2.2_Class_6
P. 46

Step 3:  Press the Enter key from the keyboard.


















                                                            Using MAX function

                  When you press the Enter key, the maximum marks appear in the cell G3. Using the Auto Fill feature,
                  find the maximum marks of each student. Similarly, we can find the minimum marks by using the
                  MIN() function.
                  Date and Time Functions


                        Functions                           Purpose                                Example

                                                                                          Input: =TODAY()
                   TODAY()              It returns the current date.
                                                                                          Output: 7/23/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: 7/23/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


                  Let  us use  the date  functions  in Excel by  performing the
                  following steps:

                  Step 1:  Type =TODAY() in the cell.
                  Step 2:  Press the Enter key from the keyboard.
                  When you press the Enter key, the current date appears in

                  the cell.
                                                                                            Using TODAY function
                  44    Plus (Ver. 2.2)-VI
   41   42   43   44   45   46   47   48   49   50   51