An Introduction to Management Science 13th Edition by David Anderson,Dennis Sweeney ,Thomas Williams ,Jeffrey Camm, Kipp Martin

تمرين 8

Open the workbook OM455. Save the file under a new name. OM4555 Revised. Suppose we wish to use a more refined grading system, as shown below:
Update the file to use this more refined grading system. How many of each letter grade are awarded under the new system? Hint: Build a new grading table and use VLOOKUP and an absolute reference to the table. Then use COUNTIF to count the number of each letter grade.