Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
A mathematical term; for example, =200 (greater than or equal to 200) or 100 (less than 100).
lookup value
conditional formatting
grouped data
array function
column index number
table array
Iteration
expression
The formatted appearance of cells associated with specified criteria.
lookup value
conditional formatting
grouped data
array function
column index number
table array
Iteration
expression
Column index number The position of the column within the table array. The row index number refers to the position of the row within the table array.
lookup value
conditional formatting
grouped data
array function
column index number
table array
Iteration
expression
An outline of data that users can expand or collapse to quickly display summary rows or columns.
lookup value
conditional formatting
grouped data
array function
column index number
table array
Iteration
expression
Refers to the value you want to find.
lookup value
conditional formatting
grouped data
array function
column index number
table array
Iteration
expression
The table, range, or list of cells that contains the value you want to find.
lookup value
conditional formatting
grouped data
array function
column index number
table array
Iteration
expression
The repeated recalculation of a worksheet until a specific value is reached.
lookup value
conditional formatting
grouped data
array function
column index number
table array
Iteration
expression
Array function A formula that calculates more than one variable at the same time. You must use Ctrl+Shift+Enter to complete an array function; the completed formula will be contained with braces ….
lookup value
conditional formatting
grouped data
array function
column index number
table array
Iteration
expression
Check it!
Match it!
Match it!