Question: Do question 3 in excel please. below is the sheet to base it off of. For Questions 1 and 2, manually enter the word Score

Do question 3 in excel please. below is the sheet

Do question 3 in excel please. below is the sheet to base it off of.

Do question 3 in excel please. below is the sheet

For Questions 1 and 2, manually enter the word Score into cell A1, and manually enter 68 into cell B1. 1. (5 points) Write a sub that uses the If Construct. If the value in cell B1 is greater than 75, cell B1 should be colored blue. If not, it should be colored red. 2. (6 points) 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 "Submit". 3. (8 points) Starting with the Sales Data file, write a sub using a For Each loop that counts the number of sales during the year that are greater than 9,000 but smaller than 11,000. Display the result in a message box. 4. (10 points) Create a user-defined function called Addodd with one argument (input) that sums the positive odd numbers up to the given input. For example, =AddOdd(8) would return 16. 5. (8 points) Write a sub that does the following: 1) it asks the user to input a word; 2) it enters each character of the word in order in consecutive cells going across row 6, starting with cell C6. Hint: Use a For Loop. 6. (5 points) Suppose that there is a list of exam grades in column A containing scores between 0 and 100. Assuming that you do not know ahead of time the size of the list, write a program to curve" the scores by increasing their values by 8 points (i.e., each value will be replaced with a number that is 8 points higher). [Test this problem on a second sheet in the workbook.] N M Dec 9445 D Mar 5678 11724 6229 8143 12166 K Oct 5254 7053 8687 14107 11046 5647 L Nov 13383 13263 10696 12550 9954 8972 5938 8692 13913 6824 14945 11194 8586 10394 14055 8536 9103 5282 12439 11697 12237 10194 8428 8830 14601 11825 7691 A 1 2 Region 1 3 Region 2 4 Region 3 5 Region 4 6 Region 5 7 Region 6 8 Region 7 9 Region 8 10 Region 9 11 Region 10 12 Region 11 13 Region 12 14 Region 13 15 Region 14 16 Region 15 17 Region 16 18 Region 17 19 Region 18 20 Region 19 21 Region 20 22 Region 21 23 Region 22 24 Region 23 25 Region 24 26 Region 25 27 Region 26 28 Region 27 29 Region 28 30 Region 29 31 Region 30 32 Region 31 33 Region 32 34 Region 33 35 Region 34 36 Region 35 37 Region 36 38 Region 37 39 Region 38 40 Region 39 41 Region 40 42 43 14499 14414 B Jan 13531 14399 9118 5680 8511 11438 5089 13322 9324 6485 8712 11725 14101 12234 6424 11916 12222 12630 10930 8722 5788 13578 10342 10016 9306 10849 13255 13022 11410 6609 8489 7447 9140 7807 8629 9608 6675 5566 14948 12316 Feb 7014 8438 14837 14382 7202 14922 8035 10581 5997 8434 5087 8227 9371 13536 14854 11230 8437 8083 9680 11606 8192 7965 12582 6307 13890 10633 7948 12090 5631 6186 12704 5682 6709 6289 10103 10997 12171 5313 5990 14217 F May 5357 7854 10611 13596 12145 14748 13571 5156 14892 9517 13184 9166 11616 9013 5920 12882 6870 11680 12177 12068 12646 6040 8737 7026 10989 8441 9481 7452 13445 12149 10843 9580 14551 9974 10785 11627 13903 13466 10381 11159 12747 10351 6297 12354 8748 11957 E Apr 13589 14419 6826 12194 14547 9590 12279 8118 14864 13809 10023 10941 8310 14097 6406 10275 13237 13143 9104 8622 10506 14850 5558 5944 6789 9581 12091 12344 14572 5029 8855 10196 5490 13829 8637 9813 5687 G Jun 8169 5005 8652 9343 12095 8338 13288 10260 13231 13962 7467 10904 14094 13585 13635 8879 11955 7930 12418 9321 6584 10949 6618 13039 10877 10601 9735 14219 6600 13334 13974 14277 9914 9770 11523 13202 H Jul 8907 7679 6725 13795 10812 12141 6021 14481 6601 12928 11559 12369 11999 6092 5980 6058 9473 11795 9918 11350 13702 9339 5045 12108 12508 12654 5775 11494 13143 11339 5466 14552 8181 12219 6730 12119 10842 7176 6387 11462 Aug 14055 14472 14304 14087 9329 9007 9244 8532 11043 10607 5650 12897 9877 9401 8475 13853 14582 12699 10555 7182 9667 14645 6490 12322 12848 9851 9651 13387 5637 6580 6568 6201 6481 10512 10701 6518 6473 11148 8770 5958 J Sep 5751 11185 12708 9826 9375 11647 7508 6871 5209 10149 10163 9152 13700 12778 7053 14637 7667 6347 10359 11096 11578 11946 7903 11267 12225 13106 5364 8576 6544 12126 10004 13081 7775 11935 13790 10483 12426 5068 13074 12277 5349 12908 10845 10259 8021 6327 10844 7279 14040 12986 5154 7943 8546 5101 12388 11420 12635 5308 10489 14528 11261 5925 12255 5915 9633 6314 9992 12832 13610 8871 10431 14306 13436 9875 9934 7101 8087 10362 8382 11656 12195 8232 9856 5406 8781 11393 11278 5427 11518 13019 8551 8825 8435 8217 13257 6059 8649 8696 8524 8599 14547 14752 11889 13794 7313 10179 12024 9163 7128 8623 10475 13896 12351 6744 9356 9504 9484 8359 11451 12113 7324 8487 11090 11726 14593 8652 14817 9376 12150 12879 6620 6134 14997 12481 9049 7454 8588 8539 11092 12561 14454 6483 8572 7373 11922 9904 7871 10819 11016 5345 14983 9544 8309 14732 5775 8435 6365 7636 12840 14346

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!