In MS Excel 365, which cell reference type allows the cell reference in the formula to reflect the new location after a formula is copied and pasted to another cell?

Correct option is C

A relative cell reference in MS Excel changes its reference based on the location where the formula is copied.
· For example, if the formula =A1 + B1 is copied from row 1 to row 2, it will automatically adjust to =A2 + B2.
This is the default referencing behavior in Excel, making it efficient for repetitive calculations.
Important Key Points:
1. Relative references are expressed without the $ symbol (e.g., A1).
2. They are ideal for formulas that need to be applied across multiple cells dynamically.
3. Copying formulas with relative references automatically adjusts the formula to reflect the target cell's context.
Knowledge Booster:
· Absolute references: Use $ to lock the reference (e.g., $A$1) and remain fixed when copied.
· Mixed references: Combine relative and absolute references (e.g., A$1 or $A1).
· Circular references: Occur when a formula refers back to the cell it is located in, causing an error unless intentional with iterative calculations enabled.