Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
An efficient way to search for and insert a value in a cell when the desired value is stored elsewhere in the worksheet or even in a different workbook.
argument
conditional formula
criteria
relationship
table array
Power Pivot
Pivot Table
lookup function
The parameters of a function.
argument
conditional formula
criteria
relationship
table array
Power Pivot
Pivot Table
lookup function
Data in a table arranged in rows and columns. A table of text, numbers, or values that you use for the formula.
argument
conditional formula
criteria
relationship
table array
Power Pivot
Pivot Table
lookup function
A condition you specify to limit which records are returned when filtering data.
argument
conditional formula
criteria
relationship
table array
Power Pivot
Pivot Table
lookup function
A tool that offers Excel users the ability to generate PivotTables very quickly on very large data sets of tens or even hundreds of millions of rows.
argument
conditional formula
criteria
relationship
table array
Power Pivot
Pivot Table
lookup function
A highly configurable table that condenses large amounts of data. A PivotTable is used to analyze and display numerical data in detail and to answer unforeseen questions about data.
argument
conditional formula
criteria
relationship
table array
Power Pivot
Pivot Table
lookup function
A formula in which the result is determined by the presence or absence of a particular condition.
argument
conditional formula
criteria
relationship
table array
Power Pivot
Pivot Table
lookup function
A term that describes when two tables have a connection between two fields.
argument
conditional formula
criteria
relationship
table array
Power Pivot
Pivot Table
lookup function
Check it!