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: -An absolute cell reference refers to a specific cell or range of cells regardless of where the formula is located in the worksheet. Operators that specify the calculations to be performed. A reference that identifies a cell’s location in the worksheet based on its row number and column letter.

Detailed explanation-3: -A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.

Detailed explanation-4: -If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a “$” before the column letter if you want that to always stay the same. Place a “$” before a row number if you want that to always stay the same.

Detailed explanation-5: -If you want to maintain the original cell reference when you copy it, you “lock” it by putting a dollar sign ($) before the cell and column references. For example, when you copy the formula =$A$2+$B$2 from C2 to D2, the formula stays exactly the same. This is an absolute reference.