Google Sheets - Formulas/Function Review

The correct formula to add cell B1 and B2 is

• AddB1+C1
• =sum(B1+C1)
•  =B1+B2
• =sum(B1-B2)

What value would you get if you put in the formula: =A1*B1

• 2
• 3
• 4
• Error

All formulas in Google Sheets begin with the following symbol:

• +
• -
• =
• %

What value would you get if you put in the formula: =B1+C1

• 2
• 3
• 4
• Error

What number should be in E1 (based on the formula shown)?

• 1
• 3
• 5
• 9

Which is the correct formula to add cells A1 through A5?

• =SUM(A1+A5)

• =SUM(A1:A5)

• =A1+A2+A3

• =SUM(A1:A4)

Select ______________ from the functions drop-down menu to add a set of numbers together. 

• average
• count
• max
• sum

Select ___________________ from the functions menu to find the smallest value in a group.

• max
• min
• sum
• average

19. Where is the Formula Bar?

• A

• B

• C

• D

18. What is the BEST formula for finding the total value for cells B2 through B5?

• =B1++B5

• =SUM(B2:B5)

• =B2+B3+B4+B5

• =13.5+6.08+7.53+45.1