187k views
2 votes
A mixed reference "locks" one part of the cell reference while the other part can change. _______________

a. True
b. False

User FZE
by
8.5k points

1 Answer

2 votes
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.
User Aen
by
8.1k points

No related questions found

Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.