BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 80

BIS 155 Week 2 Quiz (New)
For more course tutorials visit

www.tutorialrank.com

Question 1.
reference

Question :

(TCO 2) In Excel, a relative cell

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.
Question 2. Question :
(TCO 2) Which of the following best
describes a mixed cell reference?
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
Question 3. Question :
(TCO 2) You have a cell that contains
the formula =A1*2. When you copy this formula to other cells, you