Page 66 - TechPluse_C6_Flipbook
P. 66
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
Functions Purpose Example
CONCATENATE It joins together two or more Input: =CONCATENATE
(Text1,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
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
64 Premium Edition-VI

