Answer:
The answer is : When there is a need to copy a formula and have the references update based on the new location
Explanation:
I often use this function in any spreadsheet document. Imagine, you have thousands of data in a single sheet. And you inserted one row or column. Normally, you have to update EACH CELL's formula. Imagine the work load and the effort you need to exert. But when the single cell updates all the cell's reference, formula will be affected and you don't need to re update all the cells. It saves you time and effort and worries.
