Open the workbook OM455. Save the file under a new name, OM4555Revised.xls. Suppose we wish to use

Question:

Open the workbook OM455. Save the file under a new name, OM4555Revised.xls. 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? Build a new grading table and use VLOOKUP and an absolute reference to the table. Then use COUNTIF to count the number of each lettergrade.