A relative cell reference
A) indicates a cell's specific location and the reference does not change when you copy the formula.
B) contains both an absolute and a relative cell reference.
C) indicates a cells relative location from the cell containing the formula; the reference changes when you copy the formula.
D) occurs when a formula directly or indirectly refers to the cell containing the formula.
Correct Answer:
Verified
Q11: Excel displays a green arrow in the
Q12: An Argument (as it applies to Excel
Q13: A formula in Excel must begin with
A)
Q14: An absolute cell reference
A) causes a potential
Q15: Semi-selection or pointing
A) indicates a cells relative
Q17: The SUM function
A) identifies the midpoint value
Q18: The MEDIAN function
A) displays the lowest value
Q19: For a basic mathematical expression it is
Q20: A mixed cell reference
A) occurs when a
Q21: The PV is
A) a set of range
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents