1
AssignmentMultiple Choice

Create and Use a Spreadsheet

Question 1 • CHS- TX-Professional Communications (CR)

Which formula, when filled, would use an absolute row reference?

Answer
A
=B2*B6
B
=B2/$B6
C
=$B2*C6
D
=B$2*B6

Explanation

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.