Google Sheets

The correct formula to add cell B1 and B2 is

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

B1 is a?

• row
• column
• cell
• sheet

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

Text wrapping in Sheets means the text will be on more than 1 line within the same cell.

• True
• False

Merging cells automatically centers the text within the merged cells.

• True
• False