FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -C$6 says the column reference is relative but the row is always row 6.

Detailed explanation-2: -Reference to a Cell Range The notation (=A1:C6) refers to cell range A1 through C6. Independently it doesn’t mean anything and Excel will return standard error #VALUE!

Detailed explanation-3: -Click the cell in which you want to enter the formula., type = (equal sign). Do one of the following, select the cell that contains the value you want or type its cell reference. You can refer to a single cell, a range of cells, a location in another worksheet, or a location in another workbook.

Detailed explanation-4: -Similarly, the bottom-right cell reference that was B$5 changed to C$5 because the column was a relative reference and so moved relatively one column to the right, while the row absolutely stayed at 5 .