Page 268 - Computer - 9(A&B)

Functions in Calc
Functions are the predefi ned formulas used to perform complex calculations and analysis. These functions
can be used in the Calc worksheet with the help of their name along with the arguments in the form of cell
references, ranges or values, which appear between parenthesis next to the function name. For example, a simple
mathematical function to calculate the sum of multiple cell values can be used as:
= SUM(A1: A10)

Function Name Arguments

The above function will show the sum of values stored in cell range A1 to A10.
Some of the commonly used functions in Calc are:

SUM( )
The SUM ( ) function is used for summing up the values in a given cell range. The syntax of using this function is:
= SUM (Argument1, Argument2…)
where SUM is the name of function and arguments can be the cell reference, cell range or fi xed values.

Multiple arguments can be used separated by comma (,) operator.
For Example, = SUM (A1, A2, A3) [Use of multiple cell address]
or = SUM (A1: A10, B1: B10) [Use of cell ranges]
or = SUM (10, 5, 4) [Use of constant values]

A cell range used as an argument to a
function automatically ignores the text or
empty cell values.

AVERAGE( )

The AVERAGE( ) function is used to calculate the average or mean of a series of numbers in a cell range. The
syntax of this function is same as that of SUM function, i.e.,
= AVERAGE (Argument 1, Argument 2…)
where AVERAGE is the function name and arguments can be the cell range(s), cell references or constants.
For Example, = AVERAGE (A1: A10)
or = AVERAGE (A1, A5, A10)
or = AVERAGE (10, 15, 60, 80)

130
130