Google Sheets 1 Final Assessment

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

What value would the function =COUNT(A2:A7) return?

• 4 (four)

• 3 (three)

• 5 (five)

• 5 (five)

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

• 8 (eight)

• 6 (six)

• 2 (two)

• 4 (four)

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

• 4 (four)

• 2 (two)

• 16 (sixteen)

• 8 (eight)

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

• They cannot be forced.

• By positioning the operations from left to right.

• By using parentheses.

• By using simple formulas.

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.

Which Menu tab would you use to access the command to clear a cell's format?

• File

• Edit

• View

• Format

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

• =10+B2

• =10+F4

• =10+B4

• =10+F2

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

• An operand

• An operator

Which function would return the number 45.1?

• =MAX(A2:B5)

• =MIN(A2:B5)

• =AVERAGE(A2:B5)

• =SUM(A2:B5)