1. Build your letter grade search table preparing for a VLOOKUP search, it shall include grade bin...
Fantastic news! We've Found the answer you've been seeking!
Question:
1. Build your letter grade search table preparing for a VLOOKUP search, it shall include grade bin cut off, letter grade, and GPA for letter grades
2. Use Vlookup, Index(Match()), Xlookup to find student info. Please note you may search both original table and prepared Vlookup search table from part 1.
3. Use Goal Seek to answer required final exam score.
4. Use Index (Match ()) function to find out student names with highest; use Xlookup to find both student ID and name with the lowest GPA
Related Book For
Mathematical Interest Theory
ISBN: 9781470465681
3rd Edition
Authors: Leslie Jane, James Daniel, Federer Vaaler
Posted Date: