FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area. The path to the Logical button is (FORMULAS Tab l Function Library group). A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

Detailed explanation-2: -A formula that contains a relative cell reference changes as you copy it from one cell to another. For example, if you copy the formula =A2+B2 from cell C2 to C3, the formula references in C3 adjust downward by one row and become =A3+B3.

Detailed explanation-3: -Moving a formula: When you move a formula, the cell references within the formula do not change no matter what type of cell reference that you use. Copying a formula: When you copy a formula, relative cell references will change.

Detailed explanation-4: -By default, a cell reference is a relative reference, which means that the reference is relative to the location of the cell. If, for example, you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left (C minus A)-in the same row (2).

Detailed explanation-5: -The dollar sign in an Excel cell reference affects just one thing-it instructs Excel how to treat the reference when the formula is moved or copied to other cells. In a nutshell, using the $ sign before the row and column coordinates makes an absolute cell reference that won’t change.