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.