16
QuizMultiple Choice

Unit Test — Unit test

Question 16 • Business Information Management

Lily has a cell value in a formula listed as $C$4. Which of the following is the correct term to describe this?

Answer
A
Reference
B
Relative Reference
C
Absolute Reference
D
Static Reference

Explanation

The dollar signs in $C$4 lock both the column (C) and the row (4), so the reference does not change when the formula is copied to another cell. This is an absolute reference, so the correct choice is “Absolute Reference.”

AI-written and checked against the verified answer.

Previous
Next