EXCEL FORMULA ASSESSMENT

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

Assembles two or more text strings into one

• CONCATENATE

• REPLACE

• PROPER

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)

Which symbol must all formula begin with?

• =
• +
• (
• @

What text formula joins the text from two or more cells?

• concatenate

• proper

• left

• e=mc2

Why do you start a formula with an = sign?

• to tell Excel you are entering a formula

• just because

• you are entering text

Which arithmetic operator is being used in the following formula: =T75- AA45

• addition

• multiplication

• subtraction

• format