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

Explanation

$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.