Page 36 - Digicode_AI_class_6
P. 36

Let us use the date and time functions in Excel. To use the date functions, follow the given steps:


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




















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

            When you press the Enter key, the current date appears in cell A1 and current month appears in
            cell A2.

            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.






                     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.





                                                                                  Information Literacy
                   byte Quest                                                     Critical Thinking



                 Write the output of the following:

                 1. =MIN (5,7,8)
                 2. =Left("Computer", 4)
                 3. =AVERAGE(12,3,6)
                 4. =LEN("Touch")

                 5. =COUNT(4,8,12)










                 34    DigiCode AI-VI
   31   32   33   34   35   36   37   38   39   40   41