Question

rewrite the excel formula = c$3*$d$4 - $b2 after it has been moved as specified below. (a) down 2 cells (b) right 3 cells (starting with formula = c$3*$d$4 - $b2) (c) up 1 cell (starting with formula = c$3*$d$4 - $b2) (d) left 1 cell (starting with formula = c$3*$d$4 - $b2) (a) choose the correct answer below a. = f$3*$g$4 - $e2 b. = c$3*$d$4 - $b4 c. = e$3*$d$4 - $b2 d. = c$5*$d$6 - $b4

Explanation:

Step1: Analyze absolute/relative references

In Excel, absolute references (e.g., $\$C\$3$, $\$D\$4$) don't change when moved. Relative references (e.g., $B2$) change based on movement. Here, $C\$3$ (column relative, row absolute), $\$D\$4$ (absolute), $\$B2$ (column absolute, row relative).

Step2: Move down 2 cells

Moving down 2 cells affects row numbers of relative row references. For $\$B2$, row 2 + 2 = 4, so $\$B2$ becomes $\$B4$. Absolute/row - absolute references ($C\$3$, $\$D\$4$) don't change. So the formula is $=C\$3*\$D\$4 - \$B4$.

Answer:

B. $=C\$3*\$D\$4 - \$B4$