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

=ISNUMBER(value)

Return the k-th smallest value in a range

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

Repeat a specific text string by a number of instances.

REPT(text, number_times)

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

SUMIF(range,criteria,[sum range])

Return the serial number of the current date and time

=NOW()

Returns the arithmetic mean or average of a data set.

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

Lookup values in vertical or horizontal ranges

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

Return the largest value in a range of values

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

Return the reverse of TRUE or FALSE statements based on testing logical conditions

=NOT(logical)

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

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

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

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

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)