The following data is entered in the cells of an Excel sheet. Range from B1 to B

Question

The following data is entered in the cells of an Excel sheet. Range from B1 to B7 = 7,5,7,3,7,8,7 Range from C1 to C7 = 8,6,11,8,4,3,9 If the value in the cell D9 is 7, the output of the function =SUMIF(B1:B7, D9,C1:C7) is A. 12 B. 28 C. 32 D. 39 E. 45
The following data is entered in the cells of an Excel sheet. Range from B1 to B7 = 7,5,7,3,7,8,7 Range from C1 to C7 = 8,6,11,8,4,3,9 If the value in the cell D9 is 7, the output of the function =SUMIF(B1:B7, D9,C1:C7) is A. 12 B. 28 C. 32 D. 39 E. 45
Range from B1 to B7 = 7,5,7,3,7,8,7 Range from C1 to C7 = 8,6,11,8,4,3,9 Range from C1 to C7 = 8,6,11,8,4,3,9 If the value in the cell D9 is 7, the output of the function =SUMIF(B1:B7, D9,C1:C7) is A. 12 B. 28 C. 32 D. 39 E. 45

Explanation / Answer

We do the process. We put in the entries from B1 to B7 and C1 to C7, and at D9.

Then we type =SUMIF(B1:B7, D9,C1:C7) to get

OPTION C: 32 [ANSWER]

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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