Question: Generate a VBA function that receives a test score for a student from Excel, and returns a letter grade for the student. Use the following

Generate a VBA function that receives a test score for a student from Excel, and returns a letter grade for the student. Use the following criteria: o o o o o If the test score is 90 or higher, the student receives an A If the test score is 80 to 89, the student receives a B If the test score is 70 to 79, the student receives a C If the test score is 60 to 69, the student receives a D If the test score is below 59, the student receives an F Hint: A good program will guard against test scores that don't make sense! Your program function is called from with a message: "Bad Test Score" should also check for these and return a string to the cell where the Delivery detail: You cannot use Subroutines to complete this task and only a single function is to be submitted
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
