Page 308 - TP_IT_V1.0_C9_flipbpookl
P. 308
Tick ( ) if you know this.
Labels in a cell are always left aligned by default.
Values in a cell are always right aligned.
Formulas always begin with an equal = sign.
WHAT ARE FUNCTIONS?
A function is a pre-defined formula in a spreadsheet that has a name followed by parentheses. For example, MAX(),
MIN(), SUM(), etc. We write the arguments of the function inside the parentheses in the form of values, cell addresses,
or cell ranges, so that the output of the function is generated based on the given arguments. A comma (,) is used to
separate the arguments in a function.
Spreadsheet applications contain various functions to meet the needs of different fields.
The different ways of writing functions are listed below:
• When values are in a continuous range of cells
=Min(D7:D11)
• When values are scattered in different cells
=Min(D7,E12,Y56,B32)
• When values are constants
=Min(100,200,3452)
• When values are a combination of cell range and a different cell address
=Min(D7:D10,G40)
• When values are a combination of constant and cell address
=Min(120,D9:D11,R12)
Functions simplify the process of calculations and can be used to perform simple and complex calculations. The name
of the function in LibreOffice Calc is not case-sensitive.
Let us now do some of the commonly used functions using the given sheet:
To open the
Function Wizard:
Short key Ctrl + F2
306 Trackpad Information Technology (Ver. 1.0)-IX

