Respuesta :

$ sign means you lock the value of B3.

Which means, when you apply this formula to the whole column, B3 will remain unchanged, but value from C column will change even you type in C7

Answer:

— The C7 cell reference will increase to C8 and $B$3 will increase to$B$4.

Explanation:

™ ✓