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

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
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.
abtract
relative
mixed
absolute

Question 4. Question :
(TCO 2) In Excel, an argument would be
best described by which of the following statements?

Calculates the total of values contained in two or more cells