Page 24 - Touchpad_Plus_V3.2_Class 7
P. 24
This reference has 3 parts:
1. The workbook name and address in square brackets
2. The worksheet Sheet 1 preceded by #$ signs
3. The cell having relative reference preceded by period (.) sign
Hence, referencing cells in external workbooks is done by selecting the workbook, then
worksheet,and then the cell you want to link reference to.
FUNCTIONS
Functions are predefined formulas in Calc to perform both simple and complex calculations.
They accept arguments and return values. Arguments are input to functions. These values can be
number or text. The values are given in parenthesis. Return values display the function output.
Rules for using Functions
All Calc functions must begin with = sign
Function name must be a valid Calc name.
Function must be followed by opening and closing parenthesis.
Functions must contain an argument within it.
Type of Functions
LibreOffice Calc provides the following categories of functions:
Date & Time Functions: Calculates the day, month and year in a date and the hour, minute
and second in a particular time.
Logical Functions: Evaluates conditions such as Y < 3 and give the result as true or false.
Mathematical Functions: Calculates the square root or absolute value of a number, product
of numbers, etc.
Statistical Functions: Calculates the maximum, minimum, average, etc. of a set of numeric data.
Text Functions: Performs a number of operations on strings (i.e. a collection of characters
like 'hello', 'friend', 'computer', etc.) such as finding the length of a string, joining two strings,
searching for one string inside another etc.
Let us discuss these categories in detail.
Mathematical Functions
Some of the mathematical functions are given in the table below:
Functions Purpose Example
SUM(Number1, Number It returns the sum of given Input: =SUM(3,6,9,12)
2, …) OR SUM(Range) numbers or a range. Output: 30
PRODUCT(Number1, It multiplies the given values or a Input: =PRODUCT(2,5,9)
Number 2, …) OR range of cells. Output: 90
PRODUCT(Range)
MOD(Dividend, Divisor) It returns the remainder after a Input: =MOD(15,7)
dividend is divided by the divisor. Output: 1
22 Plus (Ver. 3.2)-VII

