Ask Question
23 January, 06:51

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.

+1
Answers (1)
  1. 23 January, 07:15
    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 & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers