Bis 155 Week 2 Quiz Data Analysis with Spreadsheets with Lab Essay example

1314 Words May 2nd, 2016 6 Pages
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)
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
Absolute
(TCO 2) Which of the following describes the SUM function? (Points : 2)
Identifies the midpoint value in a set of values
Calculates the total of values contained in two or more cells
Calculates the arithmetic mean or average of values in a range
Displays the lowest value in a range
(TCO 2) The _____ function returns a result based on a condition. (Points : 2)
Max
Today
Find
If
(TCO 2) Which of the following best describes the COUNT function? (Points : 2)
Tallies the number of cells in a range that are not empty
Tallies the number of blank cells in a range
Displays the

Related Documents