Unit H: Analyzing Table Data

Question 1

AutoFilter

Answer 1

easily manipulate large amounts of data to view only the data you want

Question 2

Logical conditions

Answer 2

And & Or to narrow a search even further

Question 3

And logical conditions

Answer 3

display records between two values

Question 4

Or logical conditions

Answer 4

display records that satisfy either of two values

Question 5

Criteria range

Answer 5

cell range containing one row of labels (usually a copy of the column labels) and at least one additional row underneath the row of labels that contains the criteria you want to match

Question 6

And condition

Answer 6

placing criteria in the same row indicates that the record you are searching for must match both criteria

Question 7

Or condition

Answer 7

placing the criteria in the different rows indicates that the records you are searching for must match only one of the criteria

Question 8

Color Scale

Answer 8

uses a set of two, three, or four colors to convey relative values

Question 9

Icon Sets

Answer 9

lets you visually communicate relative cell values by adding icons to cells based on the values they contain

Question 10

Extract

Answer 10

place a copy of a altered table in a range that you specify in the advanced filter dialog box

Question 11

VLOOKUP

Answer 11

helps you locate specific values in a table. searches vertically down the far left column of a table then reads across the row to return the value in the column you specify

Question 12

HLOOKUP

Answer 12

use when your data is arranged horizontally in rows

Question 13

DGET

Answer 13

extracts a single record from a table that matches the criteria you specify