Reformat the workbook so it is readable, understandable, and consistent. Replace column labels, format and align the heading, and add borders and shading as appropriate.

Add a column in the grade book for final grades next to the total points earned column.

Use the VLookup function to assess final grades automatically, based on the total points column.

Using the If function, format the workbook so each student's grade shows a pass or fail $--$ P for pass, F for fail $--$ based on the total points.