1) Match the key terms with their definitions. Write the key term letter by the appropriate numbered definition. A set of rules that governs the structure and components for properly entering a function. Displays the current date. Indicates a cell's specific location; the cell reference does not change when you copy the formula. An input, such as a cell reference or value, needed to complete a function. Identifies the highest value in a range. Tallies the number of cells in a range that contain values. Looks up a value in a vertical lookup table and returns a related result from the lookup table. A range that contains data for the basis of the lookup and data to be retrieved. Calculates the arithmetic mean, or average, of values in a range. Identifies the midpoint value in a set of values. Displays the current date and time. Evaluates a condition and returns one value if the condition is true and a different value if the condition is false. Calculates the total of values contained in one or more cells. Calculates the periodic payment for a loan with a fixed interest rate and fixed term. Indicates a cell's location from the cell containing the formula; the cell reference changes when the formula is copied. 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. An expression that evaluates to true or false. Displays the lowest value in a range. Rounds a number to a specified number of digits. Can be used to return a lookup value regardless of the location of the return array