Match the key terms with their definitions.

1. A set of rules that governs the structure and components for properly entering a function.
2. Displays the current date.
3. Indicates a cells specific location; the cell reference does not change when you copy the formula.
4. An input, such as a cell reference or value, needed to complete a function.
5. Identifies the highest value in a range.
6. Tallies the number of cells in a range that contain values.
7. Looks up a value in a vertical lookup table and returns a related result from the lookup table.
8. A range that contains data for the basis of the lookup and data to be retrieved.
9. Calculates the arithmetic mean, or average, of values in a range.
10. Identifies the midpoint value in a set of values.
11. Displays the current date and time.
12. Evaluates a condition and return one value if the condition is true and a different value if the condition is false.
13. Calculates the total of values contained in one or more cells.
14. Calculates the periodic payment for a loan with a fixed interest rate and fixed term.
15. Indicates a cells location from the cell containing the formula; the cell reference changes when the formula is copied.
16. Contains both an absolute and a relative cell reference in a formula; the absolute part does not change, but the relative part does when you copy the formula.
17. An expression that evaluates to true or false.
18. Displays the lowest value in a range.
19. Rounds a number to a specified number of digits.
20. Can be used to return a lookup value regardless of the location of the return array

KEY TERMS

1. Syntax
2. Max Function
3. Absolute reference
4. MIN function
5. MEDIAN function
6. IF function
7. Relative reference
8. ROUND reference
9. Mixed reference
10. SUM function
11. COUNT function
12. lOOKUP TABLE
13. Argument
14. XLOOKUP function
15. VLOOKUP function
16. Logical test
17. TODAY function
18. PMT function
19. NOW function
20. Average function

THANK YOU