Spreadsheets-Formulas

Front

The correct formula to add cell B1 and B2 is

Back

=B1+B2

Front

B1 is a? Options: row, column, cell, sheet

Back

cell

Front

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

Back

2

Front

All formulas in Google Sheets begin with the following symbol:

Back

=

Front

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

Back

4

Front

Which is the correct formula to add cells A1 to A5? Options: =SUM(A1+A5), =SUM(A1:A5), =A1+A2+A3, =SUM(A1:A4)

Back

=SUM(A1:A5)

Front

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

Back

sum

Front

Which item is FALSE regarding charts in Google Sheets? Options: 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.

Back

Charts can't be inserted on their own sheet.

Front

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

Back

True

Front

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

Back

True