If A1 contains the formula =$D5 then on copying the cell to B2 it will become =D6 (column letter not changed).
Kui lahtris A1 on valem =$D5, siis kopeerimisel lahtrisse B2 omandab see kuju =D6 (veerutähis jääb muutmata).