Page 74 - Web_Application_v2.0_C12_Fb
P. 74

Function                                           Description
                                    It produces the square root of a positive integer.
               SQRT(X)
                                    E.g., =SQRT(9) = 3, =SQRT(2) = 1.414213562
                                    It produces the value of X that is rounded to the number of digits specified by Y.
               ROUND(X,Y)
                                    E.g., =ROUND(12.234,2)= 12.23, =ROUND(32.67,0)=33

                                    It produces the remainder of X divided by Y.
               MOD(X,Y)
                                    E.g., =MOD(11,2) = 1, =MOD(90,2) = 0
                                    It produces the value of X raised to the power of Y.
               POWER(X,Y)
                                    E.g., =POWER(5,2)=25, =POWER(-5,0.5)=#NUM!
                                    It multiplies all the given arguments.
               PRODUCT(X,Y)
                                    E.g., =PRODUCT(5,2,3) = 30, =PRODUCT(-5,6,0) = 0


              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                                           Description

               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                                          Description

               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.



                72    Touchpad Web Applications (Ver. 2.0)-XII
   69   70   71   72   73   74   75   76   77   78   79