Question

If 4 is stored in cell A1 and 2 is stored in cell B1 and 6 is stored in cell C1, which one of the following formulas will return an answer of 36?

1) A1*B1*C1
2) A1+B1+C1
3) A1-B1+C1
4) A1*B1+C1

Answer 1

The formula that will return an answer of 36 is A1*B1+C1.

Step-by-step explanation:

To find the formula that will return an answer of 36, we need to identify the formula that multiplies the values in each of the three cells and includes a summation. Looking at the options given, we can see that the formula A1*B1+C1 will give us the correct answer. This formula multiplies the values in cells A1 and B1, and then adds the value in cell C1 to the product. Using the given values, the calculation would be 4*2+6 = 8+6 = 14. Therefore, the correct formula is A1*B1+C1 to get an answer of 36.