Google Sheets Formulas and Functions

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

A (a)   symbol is required at the beginning of each function.

• =
• -
• +
• *

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

Which is the correct formula to add cells A1 to A5?

• =SUM(A1+A5)
• =SUM(A1:A5)
• =A1+A2+A3
• =SUM(A1:A4)