FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Cell reference contains one or more letters or the alphabet followed by a number where the letter or alphabet indicates the column and the number represents the row. Each cell can be located or identified by its cell reference or address, e.g., B5.

Detailed explanation-2: -A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet. For example, A1 refers to the cell at the intersection of column A and row 1; B2 refers to the second cell in column B, and so on. It is basically a cell’s column number and row number.

Detailed explanation-3: -The above formula uses both kinds of mixed cell references (one where the row is locked and one where the column is locked). Let’s analyze each cell reference and understand how it works: $B4 (and $C4) – In this reference, the dollar sign is right before the Column notation but not before the Row number.

Detailed explanation-4: -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.