Question

1. Value or formula for cell B14 (copied to C14):

a) =B13-C13
b) =SUM(B6:B13)-C13
c) =B13
d) =SUM(B6:B13)

Answer 1

a) =B13-C13 because The formula "=B13-C13" accurately calculates the difference between the values in cells B13 and C13, meeting the specified requirements without unnecessary complexity.

Step-by-step explanation:

The correct formula for cell B14 (copied to C14) is (a) =B13-C13. This formula subtracts the value in cell C13 from the value in cell B13. The subtraction operation is straightforward and aligns with the given choices.

Option (b) includes a SUM function unnecessarily, which could lead to inaccuracies or undesired results. Option (c) simply references cell B13 without performing any operation, and option (d) sums a range of cells from B6 to B13 without subtracting C13.

Therefore, option (a) is the accurate and concise formula for the specified task.

Answer 2

It sums the values in the range B6:B13 and subtracts the value in C13, providing an accurate calculation for cell B14. The correct formula for cell B14 (copied to C14) is b) =SUM(B6:B13)-C13.

Step-by-step explanation:

The formula in option b) calculates the sum of values in cells B6 to B13 and subtracts the value in cell C13. This ensures that the total sum of the range B6:B13 is considered, providing a comprehensive calculation for cell B14.

The use of the SUM function allows for a dynamic update if values in the specified range change, maintaining accuracy in the calculation. This formula accurately captures the desired computation for cell B14 and is the most suitable option among the given choices.

The correct formula for cell B14 (copied to C14) is option b) =SUM(B6:B13)-C13.