A relative cell reference:
A) indicates a cell's specific location and the reference does not change when you copy the formula to another cell or range.
B) contains both an absolute and a relative cell reference.
C) indicates a cell's relative location from the cell containing the formula;the reference changes when you copy the formula.
D) occurs when a formula directly refers to the cell containing the formula.
Correct Answer:
Verified
Q6: Syntax:
A)displays a list of functions and defined
Q6: A circular reference
A) is a predefined formula
Q7: The COUNTBLANK function:
A)tallies the number of blank
Q8: For a straightforward,basic mathematical expression,it is best
Q9: The ellipsis in function syntax indicates that:
A)you
Q10: What does a function ScreenTip do?
A)Automatically inserts
Q12: What does the TODAY function do?
A)Evaluates the
Q13: When #NAME? displays in a cell,you may
Q14: Which of the following is NOT one
Q15: An absolute cell reference:
A)causes a potential error.
B)indicates
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