Google Slides 1 Final Assessment

Front

Which of the following uses a function to calculate the total value for cells B2 through B5? Options: =SUM(B2:B5), =B2+B3+B4+B5, =13.5+6.08+7.53+45.1, =B1++B5

Back

=SUM(B2:B5)

Front

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

Back

4 (four)

Front

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

Back

6 (six)

Front

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

Back

8 (eight)

Front

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

Back

By using parentheses.

Front

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

Back

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

Front

Which Menu tab would you use to access the command to clear a cell's format? Options: File, Edit, View, Format

Back

Format

Front

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

Back

=10+B2

Front

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

Back

An operator

Front

Which function would return the number 45.1? Options: =MAX(A2:B5), =MIN(A2:B5), =AVERAGE(A2:B5), =SUM(A2:B5)

Back

=MAX(A2:B5)