Page 235 - IT_Play_V1.0 Class9
P. 235

Date and Time Functions

                 We can add the date and time in a cell. Built into LibreOffice Calc are a number of DATE and TIME functions
                 that can be used to do this.

                         Function                                             Result
                     TODAY( )                 Produces the current date; it contains no argument.

                     NOW( )                   Produces the current date and time; it contains no argument.
                                              Returns the year from a date value. E.g.
                     YEAR(“Date”)
                                             =YEAR(DATE(2024,3,2))
                                              Returns the month from a date value (1-12). E.g.,
                     MONTH(“Date”)
                                             =MONTH(DATE(2024,3,2)) returns “3” for March.

                                              Returns the day of the month from a date value. E.g.,
                     DAY(“Date”)
                                             =DAY(DATE(2024,3,2))

                 Statistical Functions

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


                    Function                                              Result
                   AVERAGE( )      Produces the average (mean) of the given arguments.
                                   E.g.,=AVERAGE(10,20,30) will display 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.

                                   E.g., =MAX(10,20,15,25) will display 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. E.g., =
                                   MIN(10,20,15,25) will display 10
                                   =MIN(A1,A2,A3) Displays the smallest value of cells A1, A2 & A3.

                                   =MIN(B2:C3) Displays the smallest value of cells B2, B3, C2 & C3.
                   COUNT( )        Produces the number of arguments enclosed in small brackets.
                                   E.g., = COUNT(1,2,15,25,3,6) will display 6
                                   =COUNT(A1:A20) Displays output: 20 (If all cells i.e., A1 to A20 contain values).


                 Logical Functions
                 Logical Functions in LibreOffice Calc check the data and return the result TRUE if the condition is true, and
                 FALSE if not. Consider the syntax of logical functions and examples of their applications in the process of
                 working with the LibreOffice Calc program.







                                                                     Applying Formula and Functions in Spreadsheet  233
   230   231   232   233   234   235   236   237   238   239   240