Question

What do you know about absolute cell refrence

Answer 1

Answer:

An absolute cell reference is a cell reference in a spreadsheet application that remains constant even if the shape or size of the spreadsheet is changed, or the reference is copied or moved to another cell or sheet. Absolute cell references are important when referring to constant values in a spreadsheet

Explanation:

Answer 2

Answer:

Using Absolute Cell References. ... An absolute cell reference is a cell address that contains a dollar sign ($) in the row or column coordinate, or both. When you enter a cell reference in a formula, Excel assumes it is a relative reference unless you change it to an absolute reference

An address or pointer that does not change. For example, in a spreadsheet, a cell with an absolute reference does not change even if copied elsewhere. Contrast with relative reference

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 ($). It can precede the column reference, the row reference, or both.

I hope it helps u :)