What does a dollar sign mean in an Excel formula?

Answer 1

It makes that locaction absolute instead of relative. It’s like saying “apartment 205” instead of ”the apartment next to mine.”