Question

You would like the spreadsheet to add the values in cell A1 and A2 and then multiply this answer by the value in cell B1. What would your formula look like? A1+A2*B1 =A1+A2*B1 =(A1+A2)*B1 =(A1+A2^B1

Answer 1

Answer:
`=(A1+A2)* B1`

Explanation:

When we add two cells in Excel A1 and A2 , then the formula will lok like :

`=A1+A2`

And, when we multiply this answer by the value in cell B1, we need to put brackets on each sides of the sum of A1 and A2, we get

`=(A1+A2)*B1`

Hence, the your formula look like :
`=(A1+A2)*B1`

Answer 2

Answer: (A1+A2) × B1

Explanation:

Here, at first we have two values that are
`A_1` and
`A_2`

And, when we add these values we get =
`( A_1 + A_2)`

Now when we multiply
`( A_1 + A_2)` by
`B_1`

We get,
`( A_1 + A_2) . B_2`

Thus, third Option is correct.