Excel Formulas and Functions

What excel function calculates the sum of values?

Calculates the mean of a group of values

• SUM

• AVERAGE

• ROUND

• COUNT

True or False:

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

• True

• False

Calculates a sum from a group of values, but just of values

that are included because a condition is met.

• COUNTIF

• SUMIF

• AVERAGEIF

Counts the number of cells in a range that match a

criteria

• COUNTIF

• SUMIF

• AVERAGEIF

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

string

• LEFT

• RIGHT

• MID

• CONCATENATE

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

• LEFT

• RIGHT

• MID

• CONCATENATE

Assembles two or more text strings into one

• CONCATENATE

• REPLACE

• PROPER

Choose the correct example:

The column is absolute; the row is relative

• =A1

• =$A1

• =A$1

• =$A$1

Choose the correct example:

The column is relative; the row is absolute

• =A1

• =$A1

• =A$1

• =$A$1