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 (b) choose the correct answer below a. = f$3*$d$4 - $e2 b. = c$6*$d$7 - $b5 c. = c$3*$d$4 - $b5 d. = f$3*$g$4 - $e2

Explanation:

Part (a)

Step1: Recall Excel Reference Rules

In Excel, absolute references (with \$) don't change, relative references do. For the formula $=C\$3*\$D\$4 - \$B2$, moving down 2 cells:

• Columns with absolute row (\$3, \$D\$4) stay.
• Row of relative reference \$B2: row 2 + 2 = 4, so \$B4.
• Column C and \$D\$4 (absolute) remain. So formula becomes $=C\$3*\$D\$4 - \$B4$, matching option B.

Part (b)

Step1: Recall Excel Reference Rules

Moving right 3 cells from $=C\$3*\$D\$4 - \$B2$:

• Absolute row references (\$3, \$D\$4) stay.
• Columns: C + 3 = F, B + 3 = E.
• So C\$3 becomes F\$3, \$B2 becomes \$E2, \$D\$4 remains. Formula: $=F\$3*\$D\$4 - \$E2$, matching option A.

Answer:

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