SmartArt Tools Fermula Ravizw-Fxacl Insert Draw Page Layout Formulas at Review V

Question

SmartArt Tools Fermula Ravizw-Fxacl Insert Draw Page Layout Formulas at Review View Design Format Tell me what you want to do X Cut E Copy Calibri(Body) .19- A' ^ , , wrap Text Normal 2 Normal 3 Normal 1 +0 io Conditional Format2;| Title 2 Irsert Delrte Format $ . % , Sort A Find& Filler Select, Nur mal Bad Clear. uralingTable Edr.ing Diagram 2 - Type your text here e Enter formulas to show Gradebook Class: OST 2852C .Aerage Test Score per Enter formulas to show: in B13 D13 .Lowes: Test Score per Test Test 1 Test 2 100 Test 3 Student Name 5 in 814:014 Adams, Angela . Highest Test Score per verage Test Soper Test 6 Boaker, Rill 63 Davidsuri, Donriie 8 Farrell, Fred 9 Lyle, Lakeisha 10 Miller, Monica 11 Pere, Pedro 12 Striith, Sari 13 Average Score 14 Lowest Score 15 Highest Score 16 13 18 199 in B15:D15 Lawest Tost score per Test - Average Test Score per in ES:E12 Highest Test Soore per Test Letter Grade by student Square Accent List Use to show fets of inormeticn cinided into cateçories. Leval 2 text appears beside a smal AvaTest Score per Student n ES:E12 of Lerel 2 text Grading Scale Av Letter Grade ro lire Prices (20 pts)Memberships (35 pts) ? ?- O Type here to search 11:16 PM 4/8/20183

Explanation / Answer

1. Average test score per test : B13

=average(B5:B12)

2. Lowest test score per test : B14

=min(B5:B12)

3. Highest test score per test : B15

=max(B5:B12)

4. Average test score per student : E5

=average(B5:D5)

5. Letter grade of student based on his/her average :

=vlookup($E5, $B$19:$C$24,2,false)

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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