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: -You can refer to cells that are on other worksheets in the same workbook by prepending the name of the worksheet followed by an exclamation point (!) to the start of the cell reference.

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: -A range reference is represented by the address of the upper left cell and the lower right cell separated with a colon. For example, the range A1:C2 includes 6 cells from A1 through C2.