Functions in Sheets

Vocabulary

100

Function

An operation/expression that makes a calculation based on your data

200

Range

The selected group of cells that the function, rule, etc. will apply to

300

Arguments

The values that go inside the formula expression and tell the formula what you want it to do

400

What separates the starting cell and ending cell in the range?

Colon ( : )

500

What separates the arguments of a function?

Comma ( , )

Function Names

100

What is the name of the following function:

=SUM(G4:G10)

SUM

200

What is the name of the following function?

=COUNTIF(A1:A5,"Monday")

COUNTIF

300

What is the name of the following function:

=FILTER(C3:C20, D3:D20="red")

FILTER

Range

100

What is the range of the following function?

=SUM(B36:B41)

B36:B41

200

What is the range of the following function:

=COUNTIF(V6:V9,"cats")

V6:V9

300

What is the range of the following function:

=COUNTIF(K8:K16, "chocolate")

K8:K16

400

What is the range that the function will search for the search value in this function?

=FILTER(J1:J10, K1:K10="english"

K1:K10

500

What is the range for the output values in the following function:

=FILTER(B3:B19,D3:D19="summer"

B3:B19

Arguments

100

How many arguments does the following function have?

=SUM(F3:F11)

1

200

How many arguments does the following function have?

=FILTER(O9:O18,N9:N18="buckeyes")

2

300

What does the argument [B9:B15] represent in the following function?

=COUNTIF(B9:B15,"halloween")

The range of cells that will be searched for the value "halloween"

400

In the following function, which argument determines the search value and the range of cells to be searched?

=FILTER(C4:C18,D4:D18="oreos") 

D4:D18="oreos"

OR

Argument 2

500

In a COUNTIF function, which argument (1st or 2nd) determines the value that will be searched?

2nd

Function Operations

100

What does the SUM function do?

Adds together all of the numbers within the specified range

200

What does the COUNTIF function do?

Counts the number of times the specified value appears within the specified range

300

What does the FILTER function do?

Finds the cells within a specified range that line up with cells in a different range that contain a specified value.   

400

What will be the output of the following function:

=COUNTIF(H9:H17,"Fremont")

The number of times the value "Fremont" appears within the range H9:H17

500

What will be the output of the following function:

=FILTER(A1:A10, B1:B10="3:00PM"

The values in the cells within A1:A10 that line up with cells in B1:B10 that contain the value "3:00PM"