This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Jim 85 B Credit Andrew 74 C Pass Bill 54 D Fail Peter 76 C Pass Karen 96 A Distinction Ananth 34 F Fail a lot Average 77.09090909 Median 80 Highest 96 Lowest 34 Number Passing (grade > 60) 9 Number Failing (grade < 60 2 Number of A's (countif) 4 Number of B's (countif) 2 Number of C's (countif) 3 Number of D's (countif) 1 Lookup Table for Letter Grade Points Grade 0 F 50 D 65 C 80 B 90 A Lookup Table for Grade Comment Grade Comment A Distinction B Credit C Pass D Fail F Fail a lot Notes: Use "Merge Cells" to merge the notes above, and apply word wrap to this cell 1. A Vlookup table must contain the values to look up in ascending order when used to look up a range of values 2. A Vlookup table must contain distinct values to look up, e.g. one A, one B, etc....
View Full Document
This note was uploaded on 12/28/2011 for the course 198 170 taught by Professor Kristianstout during the Spring '10 term at Rutgers.
- Spring '10