Google Sheets: Working with Functions

What is a function in Google Sheets?

• A predefined formula

• A random number generator

• A text editor

• A drawing tool.

Fill in the blank: The basic syntax to create a formula with a function is to insert an _________.

• argument

• equals sign

• function name

• cell reference

Fill in the blank: A function name is followed by an _________.

• equals sign

• argument

• cell reference

• number

Fill in the blank: The function =AVERAGE(B1:B9) would calculate the ________ of the values in the cell range B1:B9.

• sum

• average

• maximum

• minimum

What does the SUM function do in Google Sheets?

• Subtracts values

• Adds values

• Multiplies values

• Divides values

The MAX function in Google Sheets is used to find: A) The lowest cell value B) The highest cell value C) The average cell value D) The total of all cell values.

• The lowest cell value

• The highest cell value

• The average cell value

• The total of all cell values.

In Google Sheets, the MIN function determines: A) The highest cell value B) The lowest cell value C) The average of cell values D) The sum of all cell values.

• The highest cell value

• The lowest cell value

• The average of cell values

• The sum of all cell values

Fill in the blank: The ______ function determines the lowest cell value in Google Sheets.

• A) SUM

• B) AVERAGE

• C) MIN

• D) MAX

What is the unit price of Salsa, Medium (1 gallon) in the table?

• $17.44

• $14.05

• $8.47

• $28.69

Fill in the blank: The total line price for 5 cases of Black Beans is ______.

• $52.32

• $100.70

• $70.25

• $93.45