An absolute cell reference:
A) causes a potential error.
B) indicates a cell's specific location and the reference does not change when you copy the formula.
C) happens only when a formula indirectly refers to the cell containing the formula.
D) contains both an absolute and a relative cell reference.
Correct Answer:
Verified
Q1: Formula AutoComplete
A) results in formulas such as
Q6: A circular reference
A) is a predefined formula
Q10: What does a function ScreenTip do?
A)Automatically inserts
Q11: A relative cell reference:
A)indicates a cell's specific
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
Q18: How many arguments are required for the
Q20: Which of the following is FALSE about
Q23: A nested function
A) contains data for the
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