Question: Professor Streterstein is a bit absentminded. His instructors grade book is a mess, and he would like your help cleaning it up and making it

Professor Streterstein is a bit absentminded. His instructors grade book is a mess, and he would like your help cleaning it up and making it easier to use. In Professor Stretersteins course, the maximum possible points a student can earn is 750. The following table displays the grade equivalent to total points for the course. grade.PNG 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. According to the information of the grade table, use the VLookup function to assess and fill final grades automatically, based on the total points column. 3. Using the If function, fill in the pass/fail column so each students grade shows a pass or failP for pass, F for failbased on the total points (>=450 pass, <450 fail).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!