Question

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.

Answer 1

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