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)
a. choose the correct answer below
a. = i3 * h6 - k5
b. = f6 * e9 - h8
c. = c3 * b6 - e5
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

Explanation:

Part a

Step1: Analyze cell movement (down 3)

For a formula moved down 3 cells, row numbers increase by 3, column letters stay (relative references).

• \( F3 \) down 3: row \( 3 + 3 = 6 \) → \( F6 \)
• \( E6 \) down 3: row \( 6 + 3 = 9 \) → \( E9 \)
• \( H5 \) down 3: row \( 5 + 3 = 8 \) → \( H8 \)

Step2: Form new formula

Combine the adjusted references: \( =F6 * E9 - H8 \), matching option B.

Part b

Step1: Analyze cell movement (right 2)

For a formula moved right 2 cells, column letters increase by 2 (A→C, F→H, E→G, H→J), row numbers stay.

• \( F3 \) right 2: column \( F + 2 = H \) → \( H3 \)
• \( E6 \) right 2: column \( E + 2 = G \) → \( G6 \)
• \( H5 \) right 2: column \( H + 2 = J \) → \( J5 \)

Step2: Form new formula

Combine the adjusted references: \( =H3 * G6 - J5 \), matching option C.

Answer:

B. \( =F6 * E9 - H8 \)