FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -In the below-mentioned screenshot, the address “B5” refers to the cell in the fifth row of column B.

Detailed explanation-2: -The correct answer is Cell address.

Detailed explanation-3: -For example, B$5 would be a relative reference to column B and an absolute reference to row 5. You could also use $B5, which would be an absolute reference to column B and a relative reference to row 5.

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