When you copy and paste a formula with mixed reference to a new location,the absolute portion of the cell reference remains fixed and the relative portion shifts._________________________

Question

Quizplus · Accepted Answer

This statement accurately describes how mixed references work when copied and pasted to new locations. The dollar sign ($) used to make a portion of the cell reference absolute keeps that part fixed, while the rest of the reference shifts relative to its new location.

When You Copy and Paste a Formula with Mixed Reference