with expline 6. When a formula contains the addross of a cell , it is called a.

Question

with expline

6. When a formula contains the addross of a cell , it is called a. Address book b. Group. C. Order of operations. d. Cell reference 7. What would be the result of the formula in cell F2 in the image below? Quarter Consultan Category 2 Quarter 3 Smith Support 102 35,200-SUMIF(A2:A11,AA,E2:E11) 3 Quarter 2 Smith 5 Quarter 1 Browning Support 7 Quarter 1 Davidson Developme 9 Quarter 2 Smith Support 5 25,900 90,000 22 3,200 pme Brow Davidson Support 1 2,600 240,500 3 1,260 10 11 Quarter 1 Browning Support 22 4,400 a. 240,000 b. 25,900 c. 100,200 d. 3,200

Explanation / Answer

Q6. Cell Reference

Q7. Option c (100,200)

SumIf(A2:11, A4, E2:E11)

The above function will consider all the rows between A2 and A11 that match the value in A4. For such matching rows, the Values between E2 and E11 will be summed up. In the above example, the sum is 100,200

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.