Question

rewrite the excel formula, =f3 * e6 - h5, after it has been moved as specified below
a. down 3 cells
b. right 2 cells (starting with formula =f3 * e6 - h5)
c. up 1 cell (starting with formula =f3 * e6 - h5)
d. left 2 cells (starting with formula =f3 * e6 - h5)

d. =f2 * e5 - h4

b. choose the correct answer below.

a. =d3 * c6 - f5
b. =f1 * e4 - h3
c. =h3 * g6 - j5
d. =f5 * e8 - h7

c. choose the correct answer below.

a. =f8 * e9 - h8
b. =f2 * e5 - h4
c. =e3 * d6 - g5
d. =g3 * f6 - i5

Explanation:

Part b (already has a checked option, but let's re-verify)

When moving a formula right 2 cells in Excel, column references increase by 2 (row references stay same for horizontal move). Original formula: $=\text{F}3 * \text{E}6 - \text{H}5$.

• $\text{F}$ (column 6) + 2 → $\text{H}$ (column 8),
• $\text{E}$ (column 5) + 2 → $\text{G}$ (column 7),
• $\text{H}$ (column 8) + 2 → $\text{J}$ (column 10).

Rows (3, 6, 5) remain. So formula becomes $=\text{H}3 * \text{G}6 - \text{J}5$, matching option C.

Part c (choosing correct answer)

Moving a formula up 1 cell in Excel: row references decrease by 1 (column references stay same for vertical move). Original formula: $=\text{F}3 * \text{E}6 - \text{H}5$.

• Row 3 (F3) - 1 → F2,
• Row 6 (E6) - 1 → E5,
• Row 5 (H5) - 1 → H4.

Columns (F, E, H) remain. So formula becomes $=\text{F}2 * \text{E}5 - \text{H}4$, matching option B.

Answer:

C. $=\text{H}3 * \text{G}6 - \text{J}5$