FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -In Excel (2007), when cells that contain absolute references (for example: $A$3 ) are copied, the absolute reference remains the same. This is by design, and the reason of using absolute references.

Detailed explanation-2: -But, if you type the formula as an absolute reference such as = $A$1+$A$2, and then copy the formula to any other location, it remains fixed as = $A$1+$A$2. You will learn how to make an absolute cell reference in the next section, so stay tuned.

Detailed explanation-3: -There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.

Detailed explanation-4: -11. Click in cell E4 and look at the formula bar to see the formula: =$C4*E$3. The absolute reference $C means that the formula will always point to column C. The $3 absolute reference means that the formula will always point to row 3. Next, you’ll copy the formula down the rest of the table.