# Bis 155 Week 2 Quiz Data Analysis with Spreadsheets with Lab

Good Essays

BIS 155 Week 2 Quiz Data Analysis with Spreadsheets with Lab
To Buy This material Click below link http://www.uoptutors.com/bis-155/bis-155-week-2-quiz-data-analysis-with-spreadsheets-with-lab (TCO 2) In Excel, a relative cell reference: (Points : 2)
Indicates a cell’s specific location and the reference does not change when you copy the formula.
Contains both an absolute and a relative cell reference
Indicates a cell’s relative location from the cell containing the formula; the reference changes when you copy the formula
Occurs when a formula directly or indirectly refers to the cell containing the formula
(TCO 2) In Excel, an Argument would be best described by which of the following statements? (Points : 2)

(Points : 2)
Contains another function embedded inside one or more of its arguments
Evaluates a condition and returns one value if the condition is true and a different value if the condition is false
Evaluates true or false
Displays the current date and time
(TCO 2) The _____ number is the number of the column in the lookup table that contains the return values. (Points : 2)
Lookup value
Column index
Lookup table
Random
(TCO 2) To copy a formula, you may use the _____, which is found in the bottom right-hand corner of an active cell. (Points : 2)
Sizing handle
Pointer
Fill handle
Insertion point
(TCO 2) One benefit of using range names in formulas is that _____ . (Points : 2)
It directly or indirectly refers to the cell containing the formula
It contains both an absolute and a relative cell reference
It identifies the present value of the loan
If you copy the formula, you do not have to make the cell reference absolute
(TCO 2) The PMT function is best described by which of the following? (Points : 2)
It is the periodic interest rate, such as a monthly interest rate
It is the total number of payment periods
It is the present value of a loan
It calculates the periodic payment for a loan with a fixed interest rate and a fixed term
(TCO 2) In Excel, a function can be defined as a _____. (Points : 2)
Predefined formula that performs a calculation
Cell reference or a value
List of values and defined names as you enter