Count the number of characters in a string

LEN(text)

Return the largest value in a range of values

MAX(number1, [number2], ...)

Calculate the average of numbers in a range that meet specific criteria.

AVERAGEIF(range, criteria, [average_range])

Replace part of a text string based on its position with new text.

REPLACE(old_text, start_num, num_chars, new_text)

Return the serial number of a particular date

=DATE (year, month, day)

Count how many values are in a list of arguments

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

Return the most common value in a data set

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

Returns a value from a list based on an index number.

=CHOOSE(index_num, value1, [value2], ...)

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

Format numbers as text by applying format codes.

TEXT(value, format_text)

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

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

Round a number down to the next multiple

=FLOOR(number, significance)

Lookup values by row in a vertical table or range

=VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])