Excel Formulas and Functions

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

• concatenate

• proper

• left

• e=mc2

Which symbol must all formula begin with?

• =
• +
• (
• @

Counts the number of cells in a range that match a

criteria

• COUNTIF

• SUMIF

• AVERAGEIF

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

that are included because a condition is met.

• COUNTIF

• SUMIF

• AVERAGEIF

Choose the correct example:

The column is absolute; the row is relative

• =A1

• =$A1

• =A$1

• =$A$1

_____ are vertical. 

• Rows
• Columns

What is the meaning of this error in Excel?

• Text in the formula is not recognized

• Trying to divide by 0

• A space was used in formulas that reference multiple ranges; a comma separates range references

Assembles two or more text strings into one

• CONCATENATE

• REPLACE

• PROPER

Which formula gets the smallest value of a range of cells?

• MAX
• MIN
• SMALL
• SUM

________ are horizontal

• Rows
• Columns