Google Sheets Basics

Each of the boxes on a Google sheet is called a

• box

• grid

• reference

• cell

Which of the following shows a range of cells?

• D6

• D2:D8

• A1,A6

• A6;A12

The best formula to enter in cell B9 to calculate the total of all ages is:

• =B3+B4+B5+B6+B7

• =(B3:B7)

• =SUM(B3:B7)

• =SUM(B3;B7)

What Microsoft program is Google Sheets similar to?

• Powerpint

• Word

• Publisher

• Excel

What do the letters A,B,C,... across the top of the sheet represent?

• Columns

• Rows

• Functions

• Cells

What do the numbers 1,2,3,... down the left side of the sheet represent?

• Columns

• Rows

• Functions

• Cells

What symbol does every formula start with?

• =

• :

• ;

• +

Which formula would add the total for a group of cells?

• =add(b2:b8)

• B2+B3+B4+B5

• SUM

• =SUM(B2:B8)