chapter 5 vocab

Edit Answers
123456789101112131415161718192021222324252627282930313233
Across
  1. 3. button Used to return records to their original order
  2. 4. tab Provides commands that allow you to alter the appearance and contents of a table quickly
  3. 7. Filter Command that allows you to enter custom criteria in the AutoFilter menu
  4. 10. field The field on which you sort prior to clicking the Subtotal button
  5. 12. sequence In order from lowest to highest
  6. 14. row Sums values of a row
  7. 15. range Used to manipulate records that pass comparison criteria
  8. 17. formatting Allows you to create rules that change the formatting of a cell based on the value of the cell
  9. 19. of cells A range of blank rows or columns on the side of a table
  10. 24. The process of filtering activity based on one or more filter criteria
  11. 25. feature Feature utilized so you can quickly hide and show detail rows
  12. 26. criterion The item you deselect from the AutoFilter menu
  13. 27. An organized collection of data
  14. 29. A function used to find the average of numbers in a table field
  15. 30. range The location to where the records are copied
  16. 32. An individual data item that makes up a record
  17. 33. A function that returns the value of a cell at the intersection of a row and column in a table or range
Down
  1. 1. A function used to sum values in a range that meet a criteria
  2. 2. level symbols Used to expand or collapse rows in a worksheet
  3. 4. A function used to count the number of numeric entries in a table field that pass a test
  4. 5. A function used to look up a value when the direction is horizontal
  5. 6. A function that tells you the relative position of an item in a range that matches a specified value in a specified order
  6. 8. A function used to count values in a range that meet a criteria
  7. 9. operator Used when every one of the comparison criteria must be true
  8. 11. keys The field or fields you select to sort records
  9. 12. The query technique that uses the column heading arrows
  10. 13. A function used to look up a value when the direction is vertical
  11. 15. column A field or column that contains formulas or functions
  12. 16. Element list Allows you to choose almost any aspect of a table to modify
  13. 18. sequence In order from highest to lowest
  14. 20. subtotals A powerful tool for summarizing data in a table
  15. 21. and center When you want to center and treat a range of cells as a single cell
  16. 22. Not available
  17. 23. Arranging records in a specific sequence
  18. 25. operator Used when only one of the comparison criteria must be true
  19. 28. column Provides alternating colors for every other column
  20. 31. Each row or a worksheet
  21. 32. handle Can be used to create a series