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