Ch. 6

2. the field or fields you select to sort
6. the field on which you sort for subtotals
9. the answer you want to appear as a result of the vlookup function
13. data sorted from highest to lowest
16. the third argument of a vlookup function
18. uses some combination of the table name, the column heading, or any named rows
19. the data related to each person or item
20. created so Excel can copy the records that meet comparison criteria in the criteria range
24. arranging records in a specific sequence
25. is a field in a table that contains a formula,function, cell reference, structured reference, or condition
26. the data you enter using AutoFilter

1. the first argument in the vlookup function
3. a separate area on a worksheet that contains functions that allow you to assign rankings based on values
4. counts the number of numeric entries in a table field that pass a test
5. an organized collection of data
7. chart that provides a hierarchical making it easy to spot patterns and trends
8. used when the table direction for a field of data is horizontal
10. data sorted from lowest to highest
11. used when a table direction is vertical
12. the characters displayed with results from AutoFilter such as ? or *
14. calculates the average of numbers in a table field that pass a test
15. the process of filtering activity based on one or more filter criteria
17. a location separate from the table used to list specific search specifications
21. include plus and minus signs for showing and hiding portions of the spreadsheet
22. the left column values in a table array
23. the individual data items that make up a record