Question 1 • CHS- TX-Professional Communications (CR)
An absolute row reference puts a dollar sign before the row number, as in B$2. In choice D, the reference B$2 keeps row 2 fixed when the formula is filled, while its column can change. The other choices either have no absolute reference or fix the column instead of the row.
AI-written and checked against the verified answer.