Page 29 - iPlus_Ver_2.0_class_8
P. 29

Functions                          Purpose                               Example

                                                                                      Input: =YEAR(TODAY())
                  YEAR(TODAY())         It returns the current year.
                                                                                      Output: 2023
                                                                                      Input: =DAY(TODAY())
                  DAY(TODAY())          It returns the current day.
                                                                                      Output: 23
                                        It returns the current  system date  and      Input: = NOW()
                  NOW()
                                        time.                                         Output: 21-05-2023 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

                 To use the date functions, follow the given steps:

                             2  Type =MONTH(TODAY()) function and press the Enter key.





















                         1  Type =TODAY() function in the cell and press the Enter key.

                 When you press the Enter key, the current date appears in the cell.

                 The month of the current date will appear. We can also give the reference of a cell containing the
                 date to the MONTH() function. Similarly, we can use the YEAR() and DAY() functions to get the
                 year and day from a date, respectively.

                    Quick Byte



                          The common functions like SUM, AVERAGE, MAX, and MIN, can
                         also be used by using the down arrow of the AutoSum command.

                          To use other functions, click on the More Functions option.










                                                                                                                  27
                                                                              Spreadsheet—Functions and Charts
   24   25   26   27   28   29   30   31   32   33   34