FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -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). When you copy a formula that contains a relative cell reference, that reference in the formula will change.

Detailed explanation-2: -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-3: -By default, every cell in Excel has a relative reference. In relative references, type “=A1+A2” in cell A3, copy and paste the formula in cell B3, and the formula automatically changes to “=B1+B2.” In absolute references, the cell address does not change when the formula is copied.

Detailed explanation-4: -Press F2 to enter the edit mode. Input your formula in one cell, and press Ctrl + Enter instead of Enter. That’s it! The formula will get copied to all of the selected cells, and Excel will adjust relative cell references accordingly.

Detailed explanation-5: -Relative Referencing is what you normally do in a spreadsheet. If you add a column of numbers, (for example), and then pull the formula to the right, you are using a relative reference.