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

