When would an absolute cell reference be most ?

when there is a long list of cell references in a formula

when there is a need to copy a formula and have the references update based on the new location

when some cell references need to be removed from a formula

when there is a need to reference the same cell when a formula is copied

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.

i think ninja is the best

answer; ///400 ibs;