FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Relative cell references are basic cell references that adjust and change when copied or when using AutoFill. Example: =SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell. Situations arise in which the cell reference must remain the same when copied or when using AutoFill.

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, 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-4: -If the formula includes relative cell references (without the $ sign), they will automatically change based on a relative position of rows and columns. So, after copying the formula, verify that the cell references have got adjusted properly and produce the result that you want.