The grades for all students in CS $170$ are stored in an Excel worksheet. A column is created in the worksheet that has the total amount of points earned for each student $(0500).$ This point total must be converted into letter grades such that $0$ to $299=$ F$,300$ to $355=$ D$,356-399=$ C$,400-449=$ B$,>450=$ A$.$

lettergrades.png

$($a$)$ Which table would be the better solution for this problem, a Pivot Table or a VLookup Table?

$($b$)$ Give the specific details on how you would create this table.

$($c$)$ How would you populate the Column C in the table above with the appropriate letter grade?