Page 59 - TP_Prime_v2.2_Class_6
P. 59

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


                  Function               Purpose                                      Example

                                                                                      Input: =TODAY()                       FORMULAS AND FUNCTIONS IN EXCEL
                  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 day.
                                                                                      Output: 2024

                                                                                      Input: =DAY(TODAY())
                  DAY(TODAY())           It returns the current day.
                                                                                      Output: 23                          57
                                         It returns  the  current  system  date  Input: = NOW()
                  NOW()
                                         and time.                                    Output: 21-05-2024 11:24
                                                                                      Input: = HOUR(NOW())
                  HOUR(time)             It returns the hour from a given time.
                                                                                      Output: 11

                                         It  returns  the minutes from  a given  Input: = MINUTE(NOW())
                  MINUTE(time)
                                         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


                      Warm              Write the output of the following:                         Century   #Critical Thinking
                                                                                                     21 st
                      Up!                                                                            Skills
                                        1.  =MIN (5,7,8)                    _____________

                                        2.  =LEFT("Computer", 4)            _____________

                                        3.  =AVERAGE(12,3,6)                _____________

                                        4.  =TODAY()                        _____________

                                        5.  =LEN("Touch")                   _____________

                                        6.  =COUNT(4,8,12)                  _____________
   54   55   56   57   58   59   60   61   62   63   64