FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Absolute references are used when you want to fix a cell location. These cell references are preceded by a dollar sign. By doing this, you are fixing the value of a particular cell reference. For example, if you type the formula = A1+A2 into A3 and copy it to another location: B3, the formula will change to = B1+B2.

Detailed explanation-2: -Excel absolute cell reference (with $ sign) The dollar sign fixes the reference to a given cell, so that it remains unchanged no matter where the formula moves. In other words, using $ in cell references allows you to copy the formula in Excel without changing references.

Detailed explanation-3: -Relative, absolute and mixed cell references. There are three types of cell references in Excel: relative, absolute and mixed. When writing a formula for a single cell, you can go with any type.

Detailed explanation-4: -An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row.