Requirements: For following tasks, please create a module in VBA and build macros to finish these tasks. You must code it manually $($i$.$e$.$ recording is not allowed in this part$).$

$$Please insert a comment to include your names$)$ at the beginning of the module.

$$Boldface the font of the label in cell A$1,$ change its font size to $14,$ and font type to "Georgia".

$$Boldface and italicize the headings in row $3,$ change their horizontal alignment to center, and vertical alignment to center.

$$Change the color of the font for the Employee ID numbers in column A to red $($any color you like$),$ and alignment to center.

$$Change the background $($the Interior property$)$ of the range with scores to light gray $($or any similar color$).$

$$Enter the label "Averages" in cell A$22$ and boldface it; enter the label "Sum" in cell A$23$ and boldface it$.$

$$Enter a formula in cell B$22$ that averages the scores above it$.$ Copy this formula to the range C$22$:$22.$ Change the horizontal alignment to right, and vertical alignment to center

$$Enter a formula in cell B$23$ that sums the scores above it$.$ Copy this formula to the range C$23$:$23.$ Change the horizontal alignment to right, and vertical alignment to center

$10$

i$.$ In a separate module $($insert$/$create another module$),$ based on the value of the score, use IF construction and loop to create a sub procedure to change the font color of the score $($one color for each range of the score$).$ You may use any colors you like:

$$score $90$

$85$ score $<mtext></mtext><mn>9</mn><mn>0</mn>$

$75$ score $<mtext></mtext><mn>8</mn><mn>5</mn>$

$65$ score $<mtext></mtext><mn>7</mn><mn>5</mn>$

$$below $65,$ do not change the font color.

$11$

$12$

Please be noted: when you save your work, make sure you save it as the xism format $($i$.$e$.$ macro$-$enabled workbook$).$ This is very important, otherwise you may lose all the macros$/$codes$.$