FUNDAMENTALS OF COMPUTER

Detailed explanation-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.

Detailed explanation-2: -An absolute cell reference in a spreadsheet application is absolute, which means that they remain consistent regardless of the size or shape of the spreadsheet or if the reference is copied or moved to another cell or sheet. For spreadsheets that contain constant values, absolute cell references are essential.

Detailed explanation-3: -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.

Detailed explanation-4: -Absolute cell reference is a method of writing a formula in a spreadsheet document so copying that formula to another cell does not change the cell its formula references. Using an absolute reference allows you to lock the column you reference, the row you reference or both.

Detailed explanation-5: -ABSOLUTE REFERENCING: In this type of referencing both parts of the cell address are fixed. For example : $B$3 iii. MIXED REFERENCING: In this type of referencing one of the parts of the cell address is fixed; either column or row is fixed.