Excel: Applications Unit 1 Quiz Review

Which function adds a range of cells?

• Sum

• Average

• =Max

• Min

What does the concatenate function do in Excel?

• Links text together

• Adds sums

• Create averages

• Creates formulas

What is the name for an expression that results in either true or false?

• Delta expression

• Average expression

• Sum expression

• Logical expression

What are the three parts of an Excel formula?

• Sigma sign, operators, and numbers

• Equal sign, operands, and operators

• Operands, operators, and hashtag

• Equal sign, Sigma sign, and letters

If C4=15 and C7=14, what is the result of the logical expression C4>C7?

• True

• False

Which of these formulas uses relative cell references?

• =5*10

• =F18/2

• =$A$10/100

• =17+$D$1

In Excel, all functions must begin with what symbol?

• !

• $

• =

• #

What symbol is used to designate an absolute cell reference?

• $

• %

• !

• #

Which type of cell references are locked and NOT automatically updated when copied?

• Absolute

• Formula

• Worksheet

• Relative

If C2=20 and D2=10, what is the result of the function =IF(C2=D2,"Full","Open")?

• Full

• 10

• Open

• Unknown