Excel 8 Flashcards
What is the auto filter
Uses filter list arrows to set criteria
What is the search criterion
Text you are searching for
What are the two comparison operators
Greater than or less than
What are the 2 logical conditions
AND OR
What is the criteria range
Cell range containing one row of labels and at least one additional row underneath containing the criteria
What is the name for the criteria in same row
AND condition
What is the name for the criteria in different rows
ORcondition
What does a color scale do
Uses sets of fill colours to convey relative values
What is extract data
Filtered data copied to different range
What does VLOOKUP do
Locates values
What other function can you use to find a record in a table that matches specified criteria
DGET
What does HLOOKUP do
Searches horizontally across the upper row of a table until it finds the matching value
What function can you use when you want the position of an item in a range
MATCH
What does the Excel data validation feature do
Allows you to specify what users can enter ins range of cells
