Find specific text and its related starting position within a text string.

FIND(find_text, within_text, [start_num])

FINDB(find_text, within_text, [start_num])

Convert text into lowercase, uppercase or capitalize the first letter in a string.

LOWER(text), UPPER(text), PROPER(text)

Return a reference that is a specified number of rows and columns from a starting point

=OFFSET(reference, rows, cols, [height], [width])

Returns the arithmetic mean or average of a data set.

=AVERAGE(number1, [number2], ...)

Return the value or reference of specified cell(s)

Array form: =INDEX(array, row_num, [column_num])

Reference form: =INDEX(reference, row_num, [column_num], [area_num])

Returns the character specified by a number

CHAR(number)

Return TRUE or FALSE statements based on testing multiple logical conditions

=OR(logical1, [logical2], ...)

Count values in a range that meet multiple specific criteria.

COUNTIFS(range1, criteria1, [range2], [criteria2], ...)

Returns a vertical array of the most common values in a data set.

=MODE.MULT(number1, [number2], ...)

Return the logical value TRUE for any error type.

=ISERROR(value)

Return an array of random decimal or integer numbers between specified values

=RANDARRAY([rows],[columns],[min],[max],[whole_number])

Lookup values by column in a horizontal table or range

=HLOOKUP (lookup_value, table_array, row_index_num, [range_lookup])

Round a number up to the next multiple

=CEILING(number, significance)