Return the k-th largest value in a range

LARGE(array, k)

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

Return the serial number of the current date and time

=NOW()

Return the relative position of a specified item in a range

=MATCH(lookup_value, lookup_array, [match_type])

Return the year, month or day component of a date

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

Count the number of characters in a string

LEN(text)

Returns the character specified by a number

CHAR(number)

Return a random integer number between 2 values

=RANDBETWEEN(bottom,top)

Sum (add) values together.

=SUM(number1,number2,…)

Return the logical value TRUE if the cell contains any value that is not text.

=ISNONTEXT(value)

Lookup values by row in a vertical table or range

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

Replace one or many instances of specific text based on its content (not on its position).

SUBSTITUTE(text, old_text, new_text, [instance_num])

Count how many numbers are in a list of arguments

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

Return the k-th smallest value in a range

SMALL(array, k)

Return the logical value TRUE if the cell contains any text.

=ISTEXT(value)

Return TRUE or FALSE statements based on testing multiple logical conditions

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

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

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