Bis 155 Week 2 Quiz Data Analysis with Spreadsheets with Lab

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) Calculates the total†¦show more content†¦(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