i am doing an excel macro assignment and need to know to do the followingcreate button 3 name cl

First, let's create Button 3 and Button 4 in your Excel sheet. To do this, follow these steps:

Question

I am doing an Excel macro assignment and need to know how to do the following: Create Button 3: Name: "Click here to calculate the desired letter grade" Action: Calculate the letter grade (based on the desired overall mark) and display it in cell H17. Use the following formula to calculate the letter grade: OVERALL GRADE LETTER GRADE >= 85 A < 85 AND >= 70 B < 70 AND >= 60 C < 60 AND >= 50 D < 50 F Create Button 4: Name: "Click here to calculate the final Exam Mark" Action: 1. Display the following message in cell F19 "Final Exam Mark / 35". 2. Calculate the final exam mark (/35) the student needs to reach the desired overall mark and display it in cell G19. 3. Display the following message in cell F20 "Final Exam Mark / 100". 4. Calculate the final exam mark (/100) the student needs to reach the desired overall mark and display it in cell G20.

          I am doing an Excel macro assignment and need to know how to do the following:
Create Button 3: 
Name: "Click here to calculate the desired letter grade" 
Action: Calculate the letter grade (based on the desired overall mark) and display it in cell H17. 
Use the following formula to calculate the letter grade: 
OVERALL GRADE LETTER GRADE 
>= 85 A 
< 85 AND >= 70 B 
< 70 AND >= 60 C 
< 60 AND >= 50 D 
< 50 F 

Create Button 4: 
Name: "Click here to calculate the final Exam Mark" 
Action: 
1. Display the following message in cell F19 "Final Exam Mark / 35". 
2. Calculate the final exam mark (/35) the student needs to reach the desired overall mark and display it in cell G19. 
3. Display the following message in cell F20 "Final Exam Mark / 100". 
4. Calculate the final exam mark (/100) the student needs to reach the desired overall mark and display it in cell G20.

Added by Jonathan S.

Question

Please give Ace some feedback