A mixed reference "locks" one part of the cell reference while the other part can change.

Name: A mixed reference "locks" one part of the cell reference while the other part can change.
Brand: Quizplus
Rating: 5.0 (44 reviews)

Question

Quizplus · Accepted Answer

A mixed reference is a reference where either the row or column remains constant while the other can change. The symbol $ is used to lock the reference.

A Mixed Reference "Locks" One Part of the Cell Reference