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