In MS Excel, which of the following is an absolutel cell reference?

ব্যাখ্যা

$B$1 is absolute. In Excel a dollar sign locks what follows it: $B locks the column and$1 locks the row. When the formula is copied, the reference still points to cell B1. Without dollar signs (B1) it is relative, and with only one ($B1 or B$1) it is mixed. Excel does not use ! or # for this.