Ask Question
21 January, 09:34

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.

+5
Answers (1)
  1. 21 January, 11:46
    0
    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".
Know the Answer?
Not Sure About the Answer?
Find an answer to your 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. ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers