This video explains how the dollar sign is used in Excel formulas to control whether cell references stay fixed or change ...
If Excel is not recognizing functions after reboot, change calculation settings, disable Show Formula, run Excel ...