9
QuizMultiple Choice

Create a Presentation — Unit test

Question 9 • Introduction to Information Technology - EL3701

Which of the following formulas would use an absolute row reference when filled?

Answer
A
=B4*B6
B
=B4/$B6
C
=$B4*B6
D
=B$4*B6

Explanation

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.

Previous
Next