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

• A. !A!1
• B. $A$1
• C. #a#1
• D. None of these