Excel 2019 Lesson 5

2. The value that is being looked up in a lookup table.
7. predesigned formatting that can be applied to a defined table, a range of cells, or to an entire worksheet
8. A logical rule by which data is tested and chosen.
9. A user-defined name that replaces a cell reference. Also called a defined name
10. A function that searches for a value in a column of a lookup table.
12. when the table is sorted from lowest to highest, earliest to most recent, or alphabetically from A to Z
15. a row that is highlighted in some way, usually applied to every other row in a table.
16. When the table is sorted from highest to lowest, most recent to earliest, or alphabetically from Z to A
17. An Excel function that calculates the sum of values for cells that match a specified criteria.
18. The individual data items that make up a record.
19. The process of filtering records based on one or more filter criteria

1. A function that returns the average of values within a range that meet a given criteria
3. a table of information in which data is looked up.
4. represents the column location of the return value within the table array
5. a field or column in a table that contains a formula, function, or cell reference
6. An organized collection of rows and columns of similarly structured data on a worksheet in Excel
8. A function that counts the number of cells within a range that meets certain criteria.
11. a row you can add to the bottom of a table for calculations using the data in the table columns.
13. Arranging records in a specific sequence
14. A box to the left of the formula bar that shows the cell reference or name of the active cell.