Page 73 - Web_Application_v2.0_C12_Fb
P. 73

Step 2:  Type = to begin your formula.
                 Step 3:  Use the mouse to click on the cell that contains the first value to include in the formula.
                 Step 4:  Type an operator like +, -, *, or / to indicate the desired calculation.
                 Step 5:   Click on other cells to include them in the formula. Each reference will appear in the formula as you
                         select it.

                 Step 6:  Press Enter key to complete the formula and view the result.
                         For example: Type =D2+D3+D4+D5+D6, the result will be 15.





















                 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.
                 For Example, A formula, say as A6=A1+A2+A3+A4+A5       Name                                Argument
                 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).

                 Mathematical Functions

                 These  functions  perform  mathematical  calculations  on  the  specified  arguments.  Some  mathematical
                 functions are:

                      Function                                           Description

                                      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)
                                      It produces the positive (absolute) value of a given integer.
                 ABS(X)
                                      E.g., =ABS(-8)=8, =ABS(4)=4, =ABS(-3.7)=3.7
                                      It produces the integer value of a given integer.
                 INT(X)
                                      E.g., =INT(12.54)=12, =INT(-8.72)=-9



                                                                                                      ICT Skills-IV  71
   68   69   70   71   72   73   74   75   76   77   78