If a cell points to cell N$8, this is an example of a(n)
A) an absolute reference to the column and a relative reference to the row
B) absolute cell reference
C) relative cell reference
D) an absolute reference to the row and a relative reference to the column

Question

Quizplus · Accepted Answer

The reference N$8 indicates that the row is absolute (denoted by the $ sign before the row number) and the column is relative (no $ sign before the column letter).

If a Cell Points to Cell N$8, This Is an Example