Spreadsheets-Formulas

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

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

Which is the correct formula to add cells A1 to 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

Which item is FALSE regarding charts in Google Sheets?

• You can create pie and line charts.
• Charts can't be inserted on their own sheet.
• You can change the chart title.
• You can put a background color on your chart.

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

• True
• False

You can have multiple sheets within the same Google Sheet document.

• True
• False