5th Six Weeks Review

Where is the Formula Bar?

• A

• B

• C

• D

• E

What number would the formula "=COUNT(A2:A7)" return?

• 4

• 3

• 5

• 6

A cell has a very long formula that you must edit. What would be the best way to edit the formula.

• Select the cell and edit the formula in the Formula Bar.

• Double-click on the cell and edit the formula in the cell.

In the formula "=F3+5", what part of the formula is the "+"?

• An operator

• An operand

In the formula "=D10+15", what part of the formula is the "15"?

• An operator

• An operand

What is the best formula for finding 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

How can you force a certain order of operations in a formula?

• By using simple formulas

• By using parentheses

• They cannot be forced

• By positioning the operations from left to right

Using the correct order of operations, what does this formula equal? =16/4*2

• 4

• 2

• 8

• 16

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

• 8

• 2

• 6

• 4

What is the argument in this formula? =COUNT(B11:H14)

• H14

• COUNT

• B11:H14

• B11