What value would be returned based on the formula in cell D49?
=SUM(A1:A10) * B2 + C5
A) The sum of values in cells A1 to A10, multiplied by the value in cell B2, plus the value in cell C5.
B) The product of values in cells A1 to A10, added to the value in cell B2, plus the value in cell C5.
C) The sum of values in cells A1 to A10, divided by the value in cell B2, plus the value in cell C5.
D) The sum of values in cells A1 to A10, plus the product of the value in cell B2 and the value in cell C5.
Correct Answer:
A) The sum of values in cells A1 to A10, multiplied by the value in cell B2, plus the value in cell C5.
What value would be returned based on the formula in cell d49