Page 48 - Plus V4 with Adobe class 6
P. 48

Functions                           Purpose                                  Example

                                                                                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

                                                                                                   Date Function
        You can use the date functions in Excel. To do so, type =TODAY()
        in the cell and press the Enter key from the keyboard.

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

        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.            Using TODAY function


                                                        Hintbot




                 To use the the common functions like SUM, AVERAGE, MAX and MIN: click
                on the down-arrow of the AutoSum command.
                 To use other functions: click on More Functions option.









                 Double Tap                                               Century   #Technology Literacy
                                                                            21 st
                                                                            Skills  #Productivity & Accountability
               Write the output of the following:

               a.  =MIN (5,7,8)                                d.  =TODAY()
               b.  =Left("Computer", 4)                        e.  =LEN("Touch")
               c.  =AVERAGE(12,3,6)                            f.  =COUNT(4,8,12)




                   Timeline


                    A cell reference is a cell address that can be used in a formula to denote a specific cell.
                    In relative reference, you actually refer to cell that is above or below and left or right to a number of
                 rows or columns.
                    If you wish to maintain the original references as they were, then you should make use of the absolute

                 references.

                    A mixed reference is a reference that refers to a specific row or column.
                    Functions are predefined formulas in Excel to perform both simple and complex calculations.



            46  Plus (Ver. 4.0)-VI
   43   44   45   46   47   48   49   50   51   52   53