If a cell included in a formula needs to remain unchanged when the formula is copied, use a(n) ________.
A) named range
B) absolute reference
C) mixed reference
D) relative reference
Correct Answer:
Verified
Q28: The formula below contains a named range.
=SUM($J$5:J$7)
Q31: The formula below contains a hard-coded value.
=B3*8.85
Q32: Hard-coding values,like sales tax in a formula,is
Q37: Names for named ranges must start with
Q155: Which of the following statements about cell
Q156: In order to simplify a formula, users
Q157: Which of the terms below would be
Q158: Which of the terms below would be
Q159: Which of the following is NOT a
Q162: Loan payment calculations and net present 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