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: -In this formula (B4*$C$1), there are two cell reference types: B4-relative cell reference that is adjusted for each row, and. $C$1-absolute cell reference that never changes no matter where the formula is copied.

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.