Which of the following is an absolute cell reference?
A ) !A!1
B ) $A$1 ✅
C ) #a#1
D ) A1
Explanation:
An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row. If it precedes the column or row (but not both), it's known as a mixed reference. You will use the relative (A2) and absolute ($A$2) formats in most formulas. Mixed references are used less frequently.