BIS 155 Week 2 Quiz( New) For more course tutorials visit www. tutorialrank. com
BIS 155 Week 2 Quiz( New) For more course tutorials visit www. tutorialrank. com
Question 1. |
Question: |
( TCO 2) In Excel, a relative cell |
reference |
|
|
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