5th Grade Google Sheets

What does the SUM function do in Google Sheets?

• Divides a series of numbers

• Finds the average of a series of numbers

• Adds up all the numbers in a range

• Multiplies a series of numbers

If you want to add the numbers in cells A1 and B1, which formula should you use?

• =A1-B1

• =A1*B1

• =A1+B1

• =SUM(A1:B1)

How do you subtract the number in cell B2 from the number in cell A2?

• =A2+B2

• =A2/B2

• =A2-B2

• =SUM(A2-B2)

To multiply the values in cells A3 and B3, which formula is correct?

• =A3+B3

• =A3*B3

• =A3-B3

• =SUM(A3*B3)

What formula would you use to divide the number in cell A4 by the number in cell B4?

• =A4+B4

• =A4-B4

• =A4*B4

• =A4/B4

Which of the following is NOT a basic chart feature in Google Sheets?

• Chart title

• Chart Type

• Data range

• Spell check

How can you format a number as currency in Google Sheets?

• Use the SUM function

• Use the multiplication symbol

• Use the currency button

• Use the addition symbol

If you want to create a pie chart of data in cells A1 through A5, what is the first step?

• Select cells A1 through A5

• Write a SUM function

• Divide the cells

• Multiply the cells

What happens if you use the SUM function on cells A1 through A5 and one of the cells is empty?

• It causes an error

• It treats the empty cell as zero

• It skips the empty cell and does not add it

• It multiplies the remaining cells

To increase the size of text in a cell, which feature should you use?

• SUM function

• Division

• Formatting options

• Multiplication