# PDF Archive

Easily share your PDF documents with your contacts, on the Web and Social Networks.

## DEVRY BIS 155 Week 2 Quiz Dat.pdf

Page 1 2 3

#### Text preview

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