excel question 2024

Question

In cell B13, create a formula without a function using absolute references that subtracts the values of cells B5 and B7 from cell B6 and then multiplies the result by cell B8. Copy the formula from cell B13 to the range C13:H13.

Answer 1

Question: In cell B13, create a formula without a function using absolute references that subtracts the values of cells B5 and B7 from cell B6 and then multiplies the result by cell B8. Copy the formula from cell B13 to the range C13:H13.

Answer: =(B$6 - B$5 - B$7) * B$8

Explanation: This formula specifies two main operations, first subtracting two values from B6 and then multiplying by B8. Importantly, since this specifies using absolute references, we can assume that the formula is meant to extend to multiple rows OR columns. Since the question is looking for us to copy the formula into a range of columns, we assume that the absolute reference should remain on the row not on the column. Once the formula is built, copy to the necessary cells and you are good to go!

Answer 2

=(B$6-(B$5+B$7))*B$8

Then use Copy to take this formula from B13 and paste it into C13:H13 (which you highlight).

Is that what you wanted to do?