Page 205 - CA 165 ver 1.0 Class 9
P. 205

Date and Time Functions


                 We can add the date and time in a cell. There are a number of DATE and TIME functions that can be
                 used to do this. Some date and time functions are:
                        Function                                            Result


                   TODAY()               Produces the current date, it contains no argument.

                   NOW()                 Produces the current date and time, it contains no argument.


                                         Produces the year of the date which is enclosed within double quotes.
                   YEAR(“Date”)
                                         Eg. =YEAR(“02/03/2009”) = 2009

                                         Produces the month of the date which is enclosed within double quotes.
                   MONTH(“Date”)
                                         Eg. =MONTH(“02/03/2009”) = 2


                                         Produces the day of the date which is enclosed within double quotes.
                   DAY(“Date”)
                                         Eg. =DAY (“02/03/2004”) = 3

                 Statistical Functions

                 Statistical Functions take numeric argument(s) and produce result accordingly. Following are the
                 different type of statistical functions:

                    Function                                            Result
                   AVERAGE( )    Produces the average (mean) of the given arguments.
                                 Eg. =AVERAGE(10;20;30) displays output: 20.

                                 =AVERAGE(A1;A2;A3) displays the average of the cells A1, A2 and A3.
                                 =AVERAGE(A1:A10) displays the average of the cells from the range A1 to A10.


                   MAX( )        Produces the largest value from the given range of cells.
                                 Eg. =MAX(10;20;15;25) displays output: 25.

                                 =MAX(A1:A5) displays the largest value from cell A1 to A5.

                                 =MAX(B2:C4) displays the largest value of cells B2, B3, B4,C2, C3 and C4.

                   MIN( )        Produces the smallest value from the given set of values/range of cells.
                                 Eg. =MIN(10;20;15;25) displays output: 10.

                                 =MIN(A1;A2;A3) displays the smallest value of cells A1, A2 and A3.

                                 =MIN(B2:C3) displays the smallest value of cells B2, B3, C2 and C3.
                   COUNT( )      Produces the number of arguments enclosed in small brackets. It can only count the
                                 numeric entries and ignores the text entries.

                                 Eg. =COUNT(1;2;15;25;3;6) displays output: 6.
                                 =COUNT(A1:A20) displays output: 20 (If all cells i.e., A1 to A20 contains values).




                                                                                                Data Analysis    203
   200   201   202   203   204   205   206   207   208   209   210