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)
a. choose the correct answer below.
a. =d3 * c6 - f5
b. =f5 * e8 - h7
c. =f1 * e4 - h3
d. =h3 * g6 - j5

Explanation:

Step1: Analyze cell movement for each reference

When a formula is moved down 2 cells, the row numbers of relative cell references increase by 2, and column letters remain the same (since we're moving vertically, columns don't change for relative references in vertical movement).

• For F3: moving down 2 cells, row 3 becomes 3 + 2 = 5, so F5.
• For E6: moving down 2 cells, row 6 becomes 6 + 2 = 8, so E8.
• For H5: moving down 2 cells, row 5 becomes 5 + 2 = 7, so H7.

Step2: Construct the new formula

Putting it together, the formula becomes =F5 * E8 - H7, which matches option B.

Answer:

B. =F5 * E8 - H7