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 w

Question

4 years ago

14

ould your formula look like? A1+A2*B1 =A1+A2*B1 =(A1+A2)*B1 =(A1+A2^B1

2 answers:

ValentinkaMS [17] · Answer 1 · 2021-12-09T07:19:42+03:00

7 0

Answer: (A1+A2) × B1

Step-by-step 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.

Margaret [11] · Answer 2 · 2021-12-09T09:11:23+03:00

Margaret [11]4 years ago

4 0

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

Step-by-step 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$