If cell E3 points to cell $F$3, but a row is inserted such that cell E3 is now cell E4, cell E4 will now point to
A) cell F4
B) cell G4
C) cell F3
D) cell G3

Question

Quizplus · Accepted Answer

When a cell reference includes a dollar sign ($) before the column letter, it means that the column reference is absolute and will not change if the cell is moved or if the spreadsheet is modified. Therefore, if cell E3 points to cell $F$3 and a row is inserted above, causing E3 to become E4, the reference will still point to cell $F$3 because the column reference is locked to column F.

If Cell E3 Points to Cell $F$3, but a Row