Why do you think spreadsheets have links of different kinds: absolute, relative?

Typically, cell references are described and used as relative. When the formula containing these references is copied, the formula is modified to maintain reference relativity.
For example, a formula that adds numbers in a column or row is then often copied for other row or column numbers. These formulas use relative references.
An absolute cell or cell area reference will always refer to the same row and column address. Regardless of the starting location, this will lead to the same location. If a formula requires the cell address to remain unchanged when copied, then an absolute reference must be used.
For example, when a formula calculates a fraction of a total, the reference to the cell containing the total should not change when copied.

Remember: The process of learning a person lasts a lifetime. The value of the same knowledge for different people may be different, it is determined by their individual characteristics and needs. Therefore, knowledge is always needed at any age and position.