More specifically, adding $ to cell references turns them from relative references to absolute or mixed references, so this should be the only time you use the dollar symbol manually in Excel.

When creating Microsoft Excel formulas, you can generate calculations using specific values ... the reference to cell E2 is absolute, represented by the dollar symbols ($) before the column ...

Cells in Excel are referred to using relative or absolute references ... hand side of the highlighted box down until "C4"; the values "No," "Yes" and "No" appear in the respective cells.

One formatting flaw is caused by Tab symbols, which are not visible, although the unwanted spaces in your spreadsheet caused by these characters are readily apparent. Using Excel's "Find and ...