Page 25 - Touchpad_Plus_V3.2_Class 7
P. 25
Functions Purpose Example
SQRT(Number) It returns the square root of the Input: =SQRT(64)
given number. Output: 8
INT(Number) It rounds down the number to an Input: =INT(17.95)
integer value. Output: 17
POWER(Base, Exponent) It returns the result of a base Input: =POWER(3,4)
raised to some exponent. Output: 81
Text Functions
Some of the text functions are given in the table below:
Functions Purpose Example
CONCATENATE(Text1, It joins together two or more Input: =CONCATENATE
Text2) different text strings. (“Libre”,“Office”)
Output: LibreOffice
LEFT(Text, Number) It returns the specified number Input: =LEFT(“LibreOffice”,4)
of characters from the left side of Output: Libr
the text string.
RIGHT(Text, Number) It returns the specified number of Input: =RIGHT(“LibreOffice”,4)
characters from the right side of Output: fice
the text string.
MID(Text, Start, Steps) It returns the specified number of Input: =MID(“LibreOffice”,4,7)
characters from the given point to Output: reOffic
the given number of steps.
LEN(Text) It returns the length of the text Input: =LEN(“LibreOffice”)
string. Output: 11
UPPER(Text) It converts the text string into Input: =UPPER(“LibreOffice”)
upper case. Output: LIBREOFFICE
LOWER(Text) It converts the text string into Input: =LOWER(”LibreOffice”)
lower case. Output: libreoffice
Statistical Functions
Some of the statistical functions are given in the table below:
Functions Purpose Example
MAX(range) It returns the largest value in the Input: =MAX(16,21,18,7,13)
given range. Output: 21
MIN(range) It returns the smallest value in the Input: =MIN(16,21,18,7,13)
given range. Output: 7
AVERAGE(range) It gives the average of the given Input: =AVERAGE(16,21,18,7,13)
numbers in a range. Output: 15
COUNT(Number1, It returns the count of the number of Input: =COUNT(6,4,8,9,7)
Number 2, …) OR given values or values in the selected Output: 5
COUNT(range) range.
Formulas, Functions and Charts in Calc 23

