In MS Excel 365, what is the Microsoft Excel formula to create an absolute cell reference for cell B2?

Correct option is B

An absolute cell reference in Excel is created by adding a dollar sign ($) before both the column letter and the row number. In this case, $B$2 ensures that both the column (B) and the row (2) remain fixed when the formula is copied to other cells.
Important Key Points:
1. Absolute reference: $B$2 locks both the column and row.
2. Mixed reference: $B2 locks only the column, and B$2 locks only the row.
3. Relative reference: B2 changes both the column and row when copied.
Knowledge Booster:
1. Absolute references are commonly used in scenarios involving fixed values, such as tax rates or constant multipliers.
2. To toggle between reference types, use the F4 key when editing a cell reference in Excel.
3. Mixed references are useful when only one dimension (row or column) needs to remain constant.