Cannect QMS Chapter 1 Flashcards Qu x? QMS Final Flashcards! Qui let x ? G Inves

Question

Cannect QMS Chapter 1 Flashcards Qu x? QMS Final Flashcards! Qui let x ? G Investment Chaicos Google x?GOperations Manage cntquc x ? é Secure https:/.newconnect.mheducation.com/flow/connect.html e Test (Midterm)I Help Save & Exit Submit 3 The question is based on the fallowing spreadsheet of the scores of 3 students obtained during the semester. Midterm 1 Midterm 2 Midterm 3 HWsPocts 2 Alice 3 Bob 50 25 75 50 50 25 50 85 COSChoose the right formula that computes Carol's final grade by dropping the worst of the Midterms and only considers the best from either the Projects or HWs (in her case it is Multiple Choice SUM(B4:F4) MAX(B4:D4)-MIN(E4-F4) SUM(B4:D4)-MIN(B4:D4)+MIN(E4 F4) SUM(B4:D4)-MIN(B4:D4)+SUM(E4:F4HMIN(E4:F4) SUM(B4:F4)+MAX(B4:D4-MIN[E4:F4) Pe 3 of 25Next>

Explanation / Answer

Maximum should be selected between hws and projects = max(E4:F4)

The minimum among the midterms = min (B4:D4)

The sum should subtract min of midterm grades and add minimum of gardens between homework and projects

C. Sum(B4:D4) - Min(B4:D4) + sum(E4:F4) - min(E4:F4)

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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