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 value 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.

Question

Computers & Technology

Sassie

22 September, 13:17

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 value 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.

+2

Answers (1)

Know the Answer?

Jaylan Jacobs · Answer 1

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".