Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a . Please insert a comment to include your name ( s ) at the beginning of the module . 3 . b . Boldface
a Please insert a comment to include your names at the beginning of the moduleb Boldface the font of the label in cell A change its font size to and font type to "Georgia".c Boldface and italicize the headings in row change their horizontal alignment to center, and vertical alignment to center.d Change the color of the font for the Employee ID numbers in column A to red any color you like and alignment to center e Change the background the Interior property of the range with scores to light gray or any similar colorf Enter the label "Averages" in cell A and boldface it; enter the label "Sum" in cell A and boldface itg Enter a formula in cell B that averages the scores above it Copy this formula to the range C:F Change the horizontal alignment to right, and vertical alignment to centerh. Enter a formula in cell B that sums the scores above it Copy this formula to the range C:F Change the horizontal alignment to right, and vertical alignment to centeri. In a separate module insertcreate 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:
a Please insert a comment to include your names at the beginning of the moduleb Boldface the font of the label in cell A change its font size to and font type to "Georgia".c Boldface and italicize the headings in row change their horizontal alignment to center, and vertical alignment to center.d Change the color of the font for the Employee ID numbers in column A to red any color you like and alignment to center e Change the background the Interior property of the range with scores to light gray or any similar colorf Enter the label "Averages" in cell A and boldface it; enter the label "Sum" in cell A and boldface itg Enter a formula in cell B that averages the scores above it Copy this formula to the range C:F Change the horizontal alignment to right, and vertical alignment to centerh. Enter a formula in cell B that sums the scores above it Copy this formula to the range C:F Change the horizontal alignment to right, and vertical alignment to centeri. In a separate module insertcreate 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:
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