A mixed cell reference
A) occurs when a formula directly or indirectly refers to the cell containing the formula.
B) causes a potential error.
C) contains absolute or relative cell references, but not both.
D) contains both an absolute and a relative cell reference.
Correct Answer:
Verified
Q15: Semi-selection or pointing
A) indicates a cells relative
Q16: A relative cell reference
A) indicates a cell's
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
Q21: The PV is
A) a set of range
Q22: The COUNTA function
A) evaluates a condition and
Q23: A nested function
A) contains data for the
Q24: The TODAY function
A) evaluates a condition and
Q25: The logical test
A) is the lowest value
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