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)
...
○ d. = c$5*$d$6 - $b4
(b) choose the correct answer below.
○ a. = f$3*$d$4 - $b2
○ b. = c$6*$d$7 - $b5
○ c. = c$3*$d$4 - $b5
○ d. = f$3*$g$4 - $e2
(c) choose the correct answer below
○ a. = d$3*$e$4 - $c2
○ b. = d$3*$d$4 - $b2
○ c. = c$2*$d$3 - $b1
○ d. = c$3*$d$4 - $b1

Explanation:

Part (a)

Answer:

\(=C\$3*\$D\$4 - \$B4\) (assuming the original formula's cell was such that moving down 2 cells affects the row of \(\$B2\) to \(\$B4\); if we re - evaluate properly:

Step1: Analyze absolute/relative references

In Excel, \(\$ \) before a column or row locks it. For \(C\$3\): column \(C\) is relative, row \(3\) is absolute. \(\$D\$4\): both column \(D\) and row \(4\) are absolute. \(\$B2\): column \(B\) is absolute, row \(2\) is relative.

Step2: Move down 2 cells

• Moving down 2 cells: for relative row references (row part of \(\$B2\) and row part of \(C\$3\) (wait, \(C\$3\) has absolute row, so row of \(C\$3\) doesn't change. Wait, no: \(C\$3\) is column \(C\) (relative), row \(3\) (absolute). So when moving down 2 cells, the column of \(C\$3\) doesn't change (since it's relative column? Wait, no: \(C\$3\) is column \(C\) (no \(\$\) before \(C\), so relative column? Wait, no, in Excel, the format is \([column][row]\), with \(\$\) locking. So \(C\$3\): column \(C\) (relative, so when moving horizontally, column changes; row \(3\) (absolute, so when moving vertically, row doesn't change). \(\$D\$4\): both column and row absolute, so no change. \(\$B2\): column \(B\) absolute (no change), row \(2\) relative. Moving down 2 cells: row of \(\$B2\) becomes \(2 + 2=4\). So the formula becomes \(=C\$3*\$D\$4-\$B4\). But if we made a mistake earlier, and the correct approach is:

Wait, maybe the original formula's cell is, say, in a cell where moving down 2 cells: for \(C\$3\): row is absolute, so row remains 3. For \(\$B2\): row is relative, so \(2+2 = 4\). So formula is \(=C\$3*\$D\$4-\$B4\). But if we consider the option D in the image (which was \(\$C\$5*\$D\$6-\$B4\)), that was wrong. The correct formula after moving down 2 cells is \(=C\$3*\$D\$4 - \$B4\) (assuming the initial cell's position leads to that; maybe my initial analysis of \(C\$3\) was wrong. Let's re - express:
If the formula is in cell (let's say) \(A1\), and we move it down 2 cells to \(A3\). The references:

• \(C\$3\): when moving down, the row is absolute, so row 3 remains. Column \(C\) is relative, but moving down doesn't change column. So \(C\$3\) stays.
• \(\$D\$4\) stays.
• \(\$B2\): column \(B\) stays, row \(2\) moves down 2 to \(4\). So formula is \(=C\$3*\$D\$4-\$B4\).

Part (b)