201k views
11 votes
Blank addresses change depending on the cells you

Blank addresses do not change if you copy them to a different cell.
copy them to.
A1) absolute
A2) mixed
A3) relative

B1) absolute
B2) mixed
B3) relative

1 Answer

3 votes

Answer:

absolute addresses change depending on the cells you copy them to.

relative addresses do not change if you copy them to a different cell.

Step-by-step explanation:

A cell reference is a single cell or range of cells on a Excel worksheet. When calculations are done, these cells can be referred to. The cells are referred to using their row value and column value.

Relative references (or addresses) changes based on the position of rows and columns when a formula is copied to a different cell.

Absolute references (or addresses) do not change (remain constant) even if the formula is copied to a different cell.

User Moylin
by
5.5k points