For Questions 1 and 2, manually enter the word Score into cell A1, and manually enter 87 into cell B1

  1. Write a sub that uses the If Construct. If the value in cell B1 is greater than 75, cell B1 should be colored green. If not, it should be colored red.

2. Write a sub that uses the Case Construction to do the following. If the number in cell B1 is at least 95, a message box should say, “You’re a star!” If it’s between 90 and 94 (inclusive), a message box should say, “Well done!” If it’s between 80 and 89 (inclusive), a message box should say, “Satisfactory performance.” And if it’s lower than 80, a message box should say, “Try again!”

Go into Excel and insert a command button that hovers above B3:C3. The button runs the sub and has the label “Feedback”.