When a cell containing a formula is copied and then pasted into a new cell, Excel:
Explanation
When you copy a formula with relative cell references, Excel automatically adjusts those references based on the new location. This feature ensures that calculations remain accurate by shifting references proportionally to the destination cell. For instance, copying a sum formula from one row to the next naturally updates the row numbers in the formula. This dynamic behavior is the core mechanism of relative referencing in spreadsheet applications. It allows users to replicate complex calculations across multiple rows or columns efficiently without manual editing. Consequently, the cell references are edited to reflect their new context within the worksheet.