Is an input, such as a cell reference or a value needed to complete a function. Is a small pop-up description that displays the results of the cell.( TCO 2) The MIN function would identify the _____.( Points: 2) The highest value in a range. Tallies the number of blank cells in a range. The lowest value in a range. The midpoint value in a range( TCO 2) The NOW function would perform which of the following?( Points: 2) FIND SEARCH HLOOKUP VLOOKUP
( TCO 2) To copy a formula, you may use the _____, which is found in the bottom righthand corner of an active cell.( Points: 2)
The periodic interest rate, such as a monthly interest rate. Calculates the periodic payment for a loan with a fixed interest rate and fixed term.
Looks up a value in a lookup table where the first column contains the values to compare with the lookup value.
Looks up a value in a lookup table in which the first row contains the values to compare with the lookup value.
( TCO 2) One benefit of using range names in formulas is that _____.( Points: 2) A cell reference A function A formula A range name