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. = f5 * e8 - h7

c. choose the correct answer below.

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

d. choose the correct answer below

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

Explanation:

Part c

When moving a formula up 1 cell in Excel, row numbers decrease by 1. For \( =F3 * E6 - H5 \):

• \( F3 \) (row 3) becomes \( F2 \) (row \( 3 - 1 = 2 \)).
• \( E6 \) (row 6) becomes \( E5 \) (row \( 6 - 1 = 5 \)).
• \( H5 \) (row 5) becomes \( H4 \) (row \( 5 - 1 = 4 \)).

So the formula is \( =F2 * E5 - H4 \), matching option B.

Part d

When moving a formula left 2 cells in Excel, column letters decrease by 2 (A=1, B=2, C=3, D=4, E=5, F=6, G=7, H=8...). For \( =F3 * E6 - H5 \):

• \( F3 \) (column 6) becomes \( D3 \) (column \( 6 - 2 = 4 \), D is column 4).
• \( E6 \) (column 5) becomes \( C6 \) (column \( 5 - 2 = 3 \), C is column 3).
• \( H5 \) (column 8) becomes \( F5 \) (column \( 8 - 2 = 6 \), F is column 6).

Row numbers stay the same (3, 6, 5). So the formula is \( =D3 * C6 - F5 \), matching option A.

Answer:

B. \( =F2 * E5 - H4 \)