Answered step by step
Verified Expert Solution
Question
1 Approved Answer
4. WhatsMyGrade Sheet (12 points, 6 points each) (Covers Learning Objectives 2, 6, 7a and 7b) a. Using IF statements and the information in the
4. WhatsMyGrade Sheet (12 points, 6 points each) (Covers Learning Objectives 2, 6, 7a and 7b) a. Using IF statements and the information in the information shown in the table in cellsB11:E21, set up cell H7 to show the letter grade for your score in cell G7. For any grade below a 72, cell H7 should show the statement "C-D, or F". b. Using some type of LOOKUP statement and the information shown I in the table in cells B11:E21, set up cell 17 to show the letter grade for your score in cell G7. Feel free to create a new grade table if that will help you complete the task. B C F Excel Midterm2 M 3 And 01 25 Error 92 30 IF Letter Grade Total Macros 03 30 Possible: Your Scores MyGrade Summary Q4 Q5 12 3 LOOKUP Letter Grade 7 8 100 0 A 9 10 11 12 13 14 15 16 17 18 19 20 21 Grade A- B B moCOOP"?> % of Course Points 95.0% 90c1%95 87% 90 846%87 BOC%84 76% % of Course Points 95.0% 90c1%95 87% 90 846%87 BOC%84 76%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started