An Excel function that determines the smallest value in a range.

An Excel function that determines the largest value in a range.

A command that enables you to select one or more rows or columns and lock them in place.

A group of functions that test for specific conditions, and which typically use conditional tests to determine whether specified conditions are true or false.

Logical functions

Conditions that you specify in a logical function.

A statistical function that counts the number of cells within a range that meet the given condition and which has two arguments$-$the range of cells to check and the criteria.

Any value or expression that can be evaluated as being true or false.

A function that uses a logical test to check whether a condition is met, and then returns one value if true and another value if false.

Symbols that evaluate each value to determine if it is the same $)=(,$ greater than $)>(,$ less than or in between a range of values as specified by the criteria.

A format that changes the appearance of a cell based on a condition.