Question: **this is for a microsoft excell class Professor Warfield teaches an Excel and Accounting Software course at Seton Hill University. The course has been very
Professor Warfield teaches an Excel and Accounting Software course at Seton Hill University. The course has been very popular because it is a requirement for EVERYONE at the University. He has compiled a Grade Summary Sheet and started a Grade Inquiry Sheet. He needs you to complete the following tasks: Grade Summary Sheet: Task \#1 Complete the formula for the "Total Points" Column J. Task \#2 Complete the formula for the "Percentage" Column K (keeping in mind that you also need to complete the Points Earned at the bottom of the sheet). 2 decimal places please. Task \#3 Complete the "Grade" Column L so that a letter grade is populated in that column. Task \#4 Professor Warfield would also like for you to make a copy of the Grade Summary Sheet, prepare a summary of letter grades indicating how many " A 's", "A-'s" etc. there are in his classes. Name this copy "Letter Grade Summary". Grade Inquiry Sheet: Task H5 When a student contacts Professor Warfield, he would like to enter the student's Last Name, comma, and the student's First Name (as it appears in the Grade summary) and have the student's information appear in rows B5 through B14. He believes that you can make this happen, given your experience
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
