Assume values 10, 20, 30, and 40 are entered in the cell range A1:A4. Cell A10 contains the formula: =A1+A2+A3+A4 and displays v

Question

3 years ago

9

alue 100. The user inserts a new row 2 and enters value 50 in cell A2. What formula and value now list in cell A11? Hint - try it.

1 answer:

r-ruslan [8.4K] · Answer 1 · 2022-08-25T19:59:49+03:00

Answer:

The formula and value to this question is "=A1+A3+A4+A5 with value 100"

Explanation:

The explanation of the given question as follows:

In question, it is defined that four cells that are "A1, A2, A3, and A4" contains value that are "10, 20, 30, and 40".
To add these values we use addition formula that is "=A1+A2+A3+A4". it will give value 100.
If the user inserts a new row that is "A2" and assigns a value in the cell that is "50" so, we use the above formula that adds values with these values we also use the value "100".