Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
Refers to the value you want to find.
grouped data
conditional formatting
function arguments
array function
lookup value
Iteration
column index number
table array
The formatted appearance of cells associated with specified criteria.
grouped data
conditional formatting
function arguments
array function
lookup value
Iteration
column index number
table array
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 ….
grouped data
conditional formatting
function arguments
array function
lookup value
Iteration
column index number
table array
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.
grouped data
conditional formatting
function arguments
array function
lookup value
Iteration
column index number
table array
Function Arguments The dialog box that helps you build a formula.
grouped data
conditional formatting
function arguments
array function
lookup value
Iteration
column index number
table array
The table, range, or list of cells that contains the value you want to find.
grouped data
conditional formatting
function arguments
array function
lookup value
Iteration
column index number
table array
An outline of data that users can expand or collapse to quickly display summary rows or columns.
grouped data
conditional formatting
function arguments
array function
lookup value
Iteration
column index number
table array
The repeated recalculation of a worksheet until a specific value is reached.
grouped data
conditional formatting
function arguments
array function
lookup value
Iteration
column index number
table array
Check it!
Match it!
Match it!