select the correct answer. which formula uses mixed cell referencing? a. c1+d1 b. $c1+$d1 c. $c$1+$d$1 d…

select the correct answer. which formula uses mixed cell referencing? a. c1+d1 b. $c1+$d1 c. $c$1+$d$1 d. c1+d$1$

select the correct answer. which formula uses mixed cell referencing? a. c1+d1 b. $c1+$d1 c. $c$1+$d$1 d. c1+d$1$

Answer

Brief Explanations:

Option A: C1+D1 is a relative cell referencing as both row and column are not fixed.
Option B: $C1+$D1 is a mixed cell referencing as column is fixed (using $ for column) and row is relative.
Option C: $C$1+$D$1 is an absolute cell referencing as both row and column are fixed.
Option D: C1+D$1 is a mixed cell referencing as row is fixed (using $ for row) and column is relative.

Answer:

B. $C1+$D1, D. C1+D$1