“DATE” - DATE Function belongs to the Date/Time Function where it returns the current
date of the system.
“ROMAN” - ROMAN Function belongs to the Math/Trig Function, it is a function that
converts a number to roman numeral. Numbers that are negative and are greater than 3999
will result into #VALUE! Error.
“SUBTOTAL” - SUBTOTAL Function is also a Math/Trig Function. When used, it returns the
subtotal of the numbers in a column of a list.
“SQR” - SQR function, a square root, belongs to the Math/Trig Function which returns the
square root of a number.
“FREQUENCY” - FREQUENCY Function is one of the Statistical Function. It returns a
vertical array of numbers on how frequent a value appears in a set of data.
“ROW” - ROW Function is a Reference Function that returns the row number of a cell
reference.
“TRANSPOSE” - TRANSPOSE Function returns a transposed range of cells. This function
can be used when there is a range of cells that you would like to arrange or is needed to be
transposed.
“REPLACE” - REPLACE Function, by its term, a set of characters will be put in the place of a
sequence of characters in a string that is needed to be replaced.
“TRIM” - TRIM Function is a Text/String Function. It returns a string or text value, and is
useful when there is an unwanted space that you would like to remove.
“VALUE” - VALUE Function returns a numeric value, a previous text value that was
converted to a number. This one belongs to the String/Text Function.
“MIN” - MIN Function is deemed as a Statistical Function that returns the smallest value from
the numbers that are provided.
“MAX” - MAX Function is also categorized as a Statistical Function, if MIN returns the
smallest value, the MAX Function returns the LARGEST value from the numbers provided.
“RANK” - RANK Function when used, it returns the rank of a number within a set of
numbers. It is also a Statistical Function.
“MEDIAN” - MEDIAN Function belongs to the Statistical Function. It is used to return the
median of a given numbers.
