( 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 )
Abstract Relative Mixed