Answer:
Option C. dollar sign is the correct answer
Explanation:
There are two types of referencing styles used in MS excel.
Relative and absolute.
Out of these two, absolute referencing is used where we don't want the cell addresses to change when the formula with cell reference is copied. Dollar sign is with the row and column number to write an absolute cell reference.
An absolute cell reference for cell C5 is written as:
$C$5
Hence,
Option C. dollar sign is the correct answer
