Answer:
$B$5 is an example of absolute cell reference
Explanation:
There are two types of referencing in MS Excel.
1. Relative
2. Absolute
Relative cell referencing changes according to the corresponding new cells when it is copied in other cells. MS Excel uses relative cell referencing by default.
Absolute cell referencing uses dollar sign with the row number and column name. When any formula with absolute referencing is copied, the cell addresses used remain the same.
From the given choices in question,
$B$5 is an example of absolute cell reference
