Question

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

d. choose the correct answer below.

Explanation:

Part d:

When moving a formula left 4 cells in Excel, each column reference (letter) decreases by 4 (since moving left reduces the column index). Let's analyze each cell reference in the original formula \( = F3 * E6 - H5 \):

• For \( F3 \): Column F (6th letter, A=1, B=2, ..., F=6). Moving left 4: \( 6 - 4 = 2 \), which is column B. Row remains 3. So \( F3 \to B3 \).
• For \( E6 \): Column E (5th letter). Moving left 4: \( 5 - 4 = 1 \), which is column A. Row remains 6. So \( E6 \to A6 \).
• For \( H5 \): Column H (8th letter). Moving left 4: \( 8 - 4 = 4 \), which is column D. Row remains 5. So \( H5 \to D5 \).

Putting it together, the formula becomes \( = B3 * A6 - D5 \), which matches option D.

Answer:

D. \( = B3 * A6 - D5 \)