Which sign or symbol will you use to lock cells for absolute cell reference? A.
ampersand
B.
asterisk
C.
dollar sign
D.
exclamation mark

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

answer; the correct answer is technician b;