Question

A cell reference that either holds row or column constant when the formula or function is copied to another location is known as:

• A. Mixed cell reference
• B. Relative cell reference
• C. Ranges
• D. Absolute cell reference

Hint:

Use mixed references for flexibility in copying formulas across rows or columns.

Answer 1

The Correct Option is A

Mixed cell reference locks either the row or column (but not both) when copying a formula. For example, in \$A1 or A\$1, the column or row respectively is fixed, useful for partial reference control. % Quick tip