Return a list of unique values in an array or range

=UNIQUE(array,[by_col],[exactly_once])

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

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

Returns the character specified by a number

CHAR(number)

Remove irregular spacing from either end of or within a text string.

TRIM(text)

Return the year, month or day component of a date

=YEAR(serial_number), =MONTH(serial_number), =DAY(serial_number)

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])

Sum (add) values in a range that meet a single criteria.

SUMIF(range,criteria,[sum range])

Return the logical value TRUE if the cell contains a number.

=ISNUMBER(value)

Round a number up to the next multiple

=CEILING(number, significance)

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])

Count how many numbers are in a list of arguments

COUNT(value1, [value2], ...)

Count the number of characters in a string

LEN(text)

Round a number down to the next multiple

=FLOOR(number, significance)