Answered step by step
Verified Expert Solution
Link Copied!

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 name(s) at the beginning of the module.3.b. Boldface the font of the label in cell A1, change its font size to 14, and font type to "Georgia".c. Boldface and italicize the headings in row 3, 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.6 e. Change the background (the Interior property) of the range with scores to light gray (or any similar color).f. Enter the label "Averages" in cell A22 and boldface it; enter the label "Sum" in cell A23 and boldface it.g. Enter a formula in cell B22 that averages the scores above it. Copy this formula to the range C22:F22. Change the horizontal alignment to right, and vertical alignment to centerh. Enter a formula in cell B23 that sums the scores above it. Copy this formula to the range C23:F23. Change the horizontal alignment to right, and vertical alignment to centeri. 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:

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions