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

ব্যাখ্যা

$B$1 is absolute. A dollar sign before the column letter and before the row number locks both, so the reference stays B1 when the formula is copied anywhere. Excel uses "!" to separate a sheet name from a cell, not to fix a reference, and "#" has no such role.