Excel Formulas and Functions

Front

What excel function calculates the sum of values?

Back

=SUM, SUM

Front

Calculates the mean of a group of values

Back

AVERAGE

Front

True or False:

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. Options: COUNTIF, SUMIF, AVERAGEIF

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

Choose the correct example: The column is absolute; the row is relative

Back

=$A1

Front

Choose the correct example: The column is relative; the row is absolute

Back

=A$1