Excel: Relative/Absolute Addressing

Cell D2 formula: =A2

Copied to Cell D3, formula: ???

• =A2

• =A3

• =B2

• =B3

Cell D4 formula: =A2

Copied to Cell G4, formula: ???

• =D2

• =F2

• =G2

• =A5

Cell D2 formula: =A2+C1

Copied to Cell E2, formula: ???

• =B2+D1

• =B3+C2

• =A2+C1

• =A3+C2

Cell D2 formula: =SUM(A2:C2)

Copied to Cell E3, formula:

• =SUM(B2:C2)

• =SUM(B2:D2)

• =SUM(B3:D3)

• =SUM(A3:C3)

Cell A2 formula: = $A$20

Copied to Cell D2, formula:

• = A20

• = $A20

• = A$20

• = $A$20

Cell A2 formula: = $B2

Copied to Cell A3, formula:

• = $B2

• = $B3

• = $C2

• = $A3

Cell B1 formula: = $B4+$C4

Copied to Cell C1, formula:

• = $B4+$C4

• = $C4+$D4

• = $B5+$C5

• = $C5+$D5

Cell B1 formula: = C$3+D$3

Copied to Cell B2, formula:

• = C$4+D$4

• = D$3+E$3

• = $C4+$D4

• = C$3+D$3

Cell B1 formula: = C$10+D$10

Copied to Cell C5, formula:

• = C$14+D$14

• = C$10+D$10

• = D$14+E$14

• = D$10+E$10

[Challenge!]

Cell C2 formula: = $A4+A$4+$A$4

Copied to Cell D3, formula:

• = $A4+A$4+$A$4

• = $A5+B$5+$B$5

• = $A5+B$4+$A$4

• = $A5+B$4+$B$5