Question

explain why absolute cell reference would be used in a formula

Answer 1

Unlike relative references, absolute references do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant. An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row.

HOPE IT IS HELPFUL FOR YOU...✌