Functions and Formulas Quiz Review

The currently selected cell in a Google Sheet is called the:

Every formula in a Google Sheet must begin with an:

This function finds the smallest numerical value in a range of cells:

• MIN

• SUM

• MAX

• AVERAGE

This function finds the largest numerical value in a range of cells:

• COUNT

• MIN

• MAX

• SUM

This function finds the average numerical value of a range of cells:

• MIN

• COUNT

• SUM

• AVERAGE

This function finds the total number of cells that contain numerical values in a Google Sheet:

• MIN

• AVERAGE

• COUNT

• MAX

This functions finds the total value, whether subtracted, added, multiplied, or divided, in a range of cells.

• SUM

• COUNT

• AVERAGE

• MAX

The type of formula that contains more than one operator:

The type of formula that contains only one operator:

Describe the difference between a simple and a complex formula on Google Sheets.