AES Excel 2: Quiz Unit 1-Using Formulas & Functions

If you copied D3 to D7, what would be the resulting cell reference in D7?

• =D10

• =D6

• =C10

• =C6

Which type of cell references are automatically updated when copied?

• Absolute

• Formula

• Worksheet

• Relative

What formula would you enter in C4 that combines A4 and B4 to get a result like in C2?

• “=A4&""&B4” “="A4"&"

• "&"B4"”

• “=A4& &B4”

• “=A4&" "&B4”

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

• False

• True

What formula should be entered to calculate the total budget?

• =B3*B4*B5*B6

• =3B+4B+5B+6B

• =3B*4B*5B*6B

• =B3+B4+B5+B6

In Excel, all functions must begin with what symbol?

• $

• !

• #

• =

If you copied C7 to D5, what would be the resulting cell reference in D5?

• =D5

• =D3

• =C3

• =C5

What function would you use to calculate the TOTAL cost?

• =SUM(B3:B6)

• =CALCULATE(B3:B6)

• =TOTAL(B3:B6)

• =AVERAGE(B3:B6)

Which of these formulas uses relative cell references?

• =17+$D$1

• =F18/2

• =5*10

• =$A$10/100

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

• Full

• Unknown

• Open

• 10