An Excel user should use a relative cell reference when it is important to ____.
A) preserve the relationship to the formula location
B) never change the formula
C) preserve the exact cell address in a formula
D) memorize the formula
Correct Answer:
Verified
Q336: Which keyboard shortcut turns on Edit mode?
A)
Q337: In this formula, =(A6*A8)+$D$1, cell references (A6*A8)
Q338: A cell reference that does not change
Q339: The Paste option from the Excel Home
Q340: In the formula =(G15-G14)*$M$3/4, which mathematical operation
Q342: Which function key on the keyboard allows
Q343: When copying or moving formulas in an
Q344: How can the order of precedence in
Q345: When cells are copied using Excel's copy
Q346: Once the Office Clipboard reaches its maximum
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