Vocabulary
Function
An operation/expression that makes a calculation based on your data
What is the name of the following function:
=SUM(G4:G10)
SUM
What is the range of the following function?
=SUM(B36:B41)
B36:B41
How many arguments does the following function have?
=SUM(F3:F11)
1
What does the SUM function do?
Adds together all of the numbers within the specified range
Range
The selected group of cells that the function, rule, etc. will apply to
What is the name of the following function?
=COUNTIF(A1:A5,"Monday")
COUNTIF
What is the range of the following function:
=COUNTIF(V6:V9,"cats")
V6:V9
How many arguments does the following function have?
=FILTER(O9:O18,N9:N18="buckeyes")
2
What does the COUNTIF function do?
Counts the number of times the specified value appears within the specified range
Arguments
The values that go inside the formula expression and tell the formula what you want it to do
What is the name of the following function:
=FILTER(C3:C20, D3:D20="red")
FILTER
What is the range of the following function:
=COUNTIF(K8:K16, "chocolate")
K8:K16
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"
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.
What separates the starting cell and ending cell in the range?
Colon ( : )
What is the range that the function will search for the search value in this function?
=FILTER(J1:J10, K1:K10="english"
K1:K10
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
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
What separates the arguments of a function?
Comma ( , )
What is the range for the output values in the following function:
=FILTER(B3:B19,D3:D19="summer"
B3:B19
In a COUNTIF function, which argument (1st or 2nd) determines the value that will be searched?
2nd
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"