Asked by Marianne Szabelski on May 01, 2024
Verified
The adjusted cell references in a copied and pasted formula are called ____ cell references.
A) related
B) relative
C) pasted
D) alternative
Relative Cell References
Relative cell references in spreadsheets are cell addresses that change when a formula is copied to other cells, adjusting based on the formula's new location.
- Learn to maneuver through Excel's interface effectively, incorporating the use of menus and command paths for a range of functions.
Verified Answer
ZK
Zybrea KnightMay 04, 2024
Final Answer :
B
Explanation :
Relative cell references adjust automatically when a formula is copied and pasted to a new location. For example, if a formula in cell E5 references cell B2, when the formula is copied to cell F6, the reference will automatically adjust to C3. These adjusted cell references are known as relative cell references. The other choices do not accurately describe this concept.
Learning Objectives
- Learn to maneuver through Excel's interface effectively, incorporating the use of menus and command paths for a range of functions.