Question

the advantage of mixed and absolute reference ​

Answer 1

Mixed references are a common feature in well-designed worksheets. They are harder to set up, but they make formulas much easier to enter. In addition, they significantly reduce errors since they allow the same formula to be copied to many cells without manual edits.

Absolute cell reference can be helpful for when you need to copy a formula into multiple cells. For example, if you need a formula that always uses the same cell value in multiple cells, if it uses a relative cell reference it would change values when copied