Using Formulas and Functions- Excel

If B3=30 and F5=10, what is the result of the function =IF(B3=F5,"Full","Open")?

• Full

• 10

• Open

• Unknown

What function would you use to calculate the TOTAL cost?

• =SUM(B3:B6)

• =CALCULATE(B3:B6)

• =TOTAL(B3:B6)

• =AVERAGE(B3:B6)

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

• =C3

• =C5

• =D3

• =D5

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 D3=30 and E9=28, what is the result of the logical expression D3>E9?

• True

• False

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

• =C10

• =D10

• =C6

• =D6

In Excel, all functions must begin with what symbol?

• $

• #

• !

• =

What term refers to mathematical equations used in Excel to perform calculations?

• Formulas

• Format

• Cell

• Summations

Which formula would you enter into D3, and then AutoFill into D4 to D6, to calculate the winning percentage (Pct.) for the teams?

• =B3/(B3+C3)

• =$B$3/(B3+C3)

• =B3/($B$3+$C$3)

• =$B$3/($B$3+$C$3)

What function would you use to find the most expensive item?

• =MAX(B3:B7)

• =SUM(B3:B7)

• =AVERAGE(B3:B7)

• =MIN(B3:B7)