Question 9 • Introduction to Information Technology - EL3701
An absolute row reference places a dollar sign before the row number, as in B$4. In choice D, =B$4*B6, the row 4 stays fixed when the formula is filled, while the column B can change. The other choices either use relative references or lock the column instead of the row.
AI-written and checked against the verified answer.