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

Explanation:

When moving a formula down 3 cells in Excel, relative cell references change:

• For \( F3 \): moving down 3 rows (row 3 + 3 = row 6), column remains F → \( F6 \).
• For \( E6 \): moving down 3 rows (row 6 + 3 = row 9), column remains E → \( E9 \).
• For \( H5 \): moving down 3 rows (row 5 + 3 = row 8), column remains H → \( H8 \).

Thus the formula becomes \( =F6 * E9 - H8 \), matching option B.

Answer:

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