Question

by default, when a formula is copied and pasted from one cell to another, excel automatically changes the cell addresses to reflect the destination location. this is referred to as ____ addressing. select one: a. relative b. static c. absolute d. offset

Explanation:

In Excel, when a formula is copied and pasted and cell - addresses change based on the destination location, it is called relative addressing. Static is not a standard Excel addressing term. Absolute addressing keeps the cell reference constant. Offset is related to calculating a new cell location based on an offset value, not the default behavior of copied - pasted formulas.

Answer:

A. relative