Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
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.
array function
conditional formatting
lookup value
table array
column index number
grouped data
expression
formula
The formatted appearance of cells associated with specified criteria.
array function
conditional formatting
lookup value
table array
column index number
grouped data
expression
formula
Refers to the value you want to find.
array function
conditional formatting
lookup value
table array
column index number
grouped data
expression
formula
The table, range, or list of cells that contains the value you want to find.
array function
conditional formatting
lookup value
table array
column index number
grouped data
expression
formula
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 ….
array function
conditional formatting
lookup value
table array
column index number
grouped data
expression
formula
A mathematical term; for example, =200 (greater than or equal to 200) or 100 (less than 100).
array function
conditional formatting
lookup value
table array
column index number
grouped data
expression
formula
An outline of data that users can expand or collapse to quickly display summary rows or columns.
array function
conditional formatting
lookup value
table array
column index number
grouped data
expression
formula
Excel functions and parameters used to perform calculations.
array function
conditional formatting
lookup value
table array
column index number
grouped data
expression
formula
Check it!