Google Sheets - Fast and Curious!

What formula would be used in cell B14 to add up the total number of miles the person biked in a month?

• =(B2+B10)

• =SUM(B2:B10)

• =SUM(B2+B10)

• =(B2*B10)

In Google Sheets, a CELL is

• a group of cells that run horizontally

• each rectangle in a spreadsheet

• a group of cells that run vertically

• the place to enter and edit data, functions, and formulas for a specific cell

In Google Sheets, a FORMULA BAR is

• a predefined formula that performs calculations using specific values in a particular order

• each rectangle in a spreadsheet

• a group of cells that run vertically

• the place to enter and edit data, functions, and formulas for a specific cell

In Google Sheets, a ROW is

• a group of cells that run horizontally

• each rectangle in a spreadsheet

• a group of cells that run vertically

• a small tab at the bottom of a worksheet that allows you to move from one worksheet to another within the same workbook.

In Google Sheets, a COLUMN is

• a group of cells that run horizontally

• a predefined formula that performs calculations using specific values in a particular order

• a group of cells that run vertically

• the place to enter and edit data, functions, and formulas for a specific cell

What symbol is required at the beginning of each function?

(a)  

In Google Sheets, a FUNCTION is

• a group of cells that run vertically

• a predefined formula that performs calculations using specific values in a particular order

• a group of cells that run horizontally

• the place to enter and edit data, functions, and formulas for a specific cell

What formula would be used in cell B14 to find the average number of miles the person biked in a month?

• =(B2/B10)

• =AVERAGE(C2:C10)

• =AVERAGE(B2+B10)

• =AVERAGE(B2:B10)

In Google Sheets, a SHEET is

• a group of cells that run vertically

• a predefined formula that performs calculations using specific values in a particular order

• A small tab at the bottom of a worksheet that allows you to move from one worksheet to another within the same workbook.

• the place to enter and edit data, functions, and formulas for a specific cell

Google Sheets is...

• similar to Microsoft Excel

• a cloud-based program

• able to be shared with others

• all of the answers