Basic Formulas and Functions

Using the correct order of operations, what does this formula equal? =4/(5-3)*2

• 1 (one)

• 2 (two)

• 3 (three)

• 4 (four)

Which of the following uses a function to calculate the total value for cells B2 through B5?

• =SUM(B2:B5)

• =B2+B3+B4+B5

• =13.5+6.08+7.53+45.1

• =B1++B5

Clicking on a cell will show its content in the Formula Bar.

• True

• False

Using the correct order of operations, what does this formula equal? =5+3*2

• 15 (fifteen)

• 10 (ten)

• 11 (eleven)

• 20 (twenty)

In the formula =A3/B3, what part of the formula is the '/'?

• An operand

• An operator

Cell A1 contains the formula =10+D2. If you copied A1 to B3, what would be the formula in B3?

• =10+E4

• =10+B3

• =10+E3

• =10+B4

What is the argument in this function? =AVERAGE(B11:H14)

• H11

• B11:H14

• B11

• AVERAGE

In the formula =10+C5, what part of the formula is the "10"?

• An operand

• An operator

• A function

• A cell reference

Where is the Formula Bar?

• A

• B

• C

• D

Which function would return the number 2?

• =MIN(A2:B5)

• =MAX(A2:B5)

• =AVERAGE(A2:B5)

• =SUM(A2:B5)