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

