use the VLOOKUP function to automatically asses final grades automatically, based on the total points column.

R Data.xisx ual to U. Project 18: Formatting Grades Professor Streterstein is a bit absentminded. His instructor's grade book is a mess, and he would like your help cleaning it up and making it easier to use. In Professor Streterstein's course, the maximum possible points a student can earn is 750.The following table displays the grade equiva- lent to total points for the course. Total Points 675 635 600 560 535 490 450 Calculated Grade A- B- C- Help Professor Streterstein rework his grade book. Open the AYK18 Data xlsx data file and perform the following: 1. Reformat the workbook so it is readable, understandable, and consistent. Replace column labels, format and align the headings, and add borders and shading as appropriate. 2. Add a column in the grade book for final grade next to the total points earned column. 3. Use the VLookup function to automatically assess final grades automatically, based on the total points column. 4. 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. Data File: AYK18 Data.xlsx Project 19: Moving Dilemma Pnny Fsnresso is a small e at offices' front entrances, and the office employees purchase a Colmbia. The business is profitable. Pony se l business that sells specialty coffee drinks at office buildings. Each morn