When a user types$=$$C$$6$ in a$$ cell, what does that$$ mean?

Question content area bottom

Part $1$

A$.$

The cell will always show as a dollar value since the user specifically referenced the dollar sign in its cell reference.

B$.$

The value will stay$$ constant, referred to as$$ 'absolute reference'.

C$.$

The user is making a relative cell reference and that if the formula is copied and pasted elsewhere that the cell will shift as appropriate.

D$.$

The cell will reflect the text$\text{'}$C$6\text{'}$ since it has a dollar sign before each column and row listed.