DEVRY BIS 155 Week 2 Quiz Dat.pdf
(TCO 2) The PMT function is best described by which of the following? (Points : 2)
It is a set of range names.
It is a word or a string of characters that represent one or more cells.
It is the present value of the loan.
It is why you do not have to make the cell reference absolute in the formula.
(TCO 2) Which of the following best describes a mixed cell reference? (Points : 2)
Occurs when a formula directly or indirectly refers to the cell containing the formula
Causes a potential error
Contains absolute or relative cell references, but not both
Contains both an absolute and a relative cell reference
(TCO 2) You have a cell that contains the formula =A1*2. When you copy this formula
to other cells, you want it to always reference column A, but you want the row
number to change automatically. You should make the A1 in this formula a(n) _____
cell reference. (Points : 2)