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: -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-5: -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.