Page 234 - IT_Play_V1.0 Class9
P. 234

FUNCTIONS

              Functions  are  in-built  formula  in  LibreOffice  Calc
              that  can  be  used  to  perform arithmetical  and                    =SUM(A1:A5)
              non-arithmetical  tasks. A function contains  Name
              and Argument.
                                                                      Name                              Argument
              For Example, A formula, say as A6=A1+A2+A3+A4+A5
              can be written using the SUM function along with the cell range A6 as: =SUM(A1:A5)
              Name is the name of the function that signifies the nature of operation. Argument specifies the values or the
              range of cells on which the specific operation is being applied and is always enclosed within the opening and
              closing parenthesis (i.e. Name refers to the operator and Argument refers to the operand).
                          Notes


                         In Spreadsheet, to denote a range of cells, it is represented between colon with address of the
                         first cell & last cell, i.e., say a range of cells from A1 to A5 will be denoted by 'A1:A5'.
                         To apply function between the selected cells among the range of cells, a comma (,) is used, i.e.,
                         for denoting two cells A1 and A2, A1, A2 is applied.



              Mathematical Functions

              These  functions  perform  mathematical  calculations  on  the  specified  arguments.  Some  mathematical
              functions are:
                    Function                                              Result
                                     It  produces  the  sum  of  the  numbers  for  a  range  of  cells.  E.g.,  =SUM(C1  ...C4),
                SUM(X,Y,..)
                                     =SUM(C1:C4) (will produce the addition of cells from C1 to C4)
                ABS(X)               It produces the positive (absolute) value of a given integer.
                                     E.g., =ABS(-8)=8, =ABS(4)=4, =ABS(-3.7)=3.7
                INT(X)               It produces the integer value of a given integer.
                                     E.g., =INT(12.54)=12, =INT(-8.72)=-9

                SQRT(X)              It produces the square root of a positive integer.
                                     E.g., =SQRT(9) = 3, =SQRT(2) = 1.414213562
                ROUND(X,Y)           It produces the value of X that is rounded to the number of digits specified by Y.
                                     E.g., =ROUND(12.234,2)= 12.23, =ROUND(32.67,0)=33
                MOD(X,Y)             It produces the remainder of X divided by Y.
                                     E.g., =MOD(11,2) = 1, =MOD(90,2) = 0
                POWER(X,Y)           It produces the value of X raised to the power of Y.
                                     E.g., =POWER(5,2)=25, =POWER(-5,0.5)=#NUM!
                PRODUCT(X,Y)         It multiplies all the given arguments.
                                     E.g., =PRODUCT(5,2,3) = 30, =PRODUCT(-5,6,0) = 0

                          Notes


                          AUTOSUM is a shortcut tool for adding the values of a range of cells. To do so:
                          Select the range of cells to be added and click on the Autosum button near the formula bar. The sum
                          is displayed in the next cell.




                232     Information Technology Play (Ver 1.0)-IX
   229   230   231   232   233   234   235   236   237   238   239