Excel Formulas and Functions

Front

What Excel function calculates the sum of values?

Back

=SUM

Front

Calculates the mean of a group of values

Back

AVERAGE

Front

The IF function tests for a true or false condition and then returns one value or another.

Back

True

Front

Calculates a sum from a group of values, but just of values that are included because a condition is met.

Back

SUMIF

Front

Counts the number of cells in a range that match a criteria.

Back

COUNTIF

Front

Extracts one or more characters from the left side of a text string.

Back

LEFT

Front

Extracts one or more characters from the right side of a text string

Back

RIGHT

Front

Assembles two or more text strings into one

Back

CONCATENATE

Front

The column is absolute; the row is relative. Options: =A1, =$A1, =A$1, =$A$1

Back

=$A1

Front

The column is relative; the row is absolute

Back

=A$1