It is true that a mixed reference "locks" one part of the cell reference while the other part can change. Mixed reference contains both relative and absolute references, where mixed reference locks one part and while the other can change. when one enters a formula into a cell, Excel interprets cell references in the formula in relation to a cell's location. In excel the numbers, text, or cell references used by the functions to return a value.