Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Requirements: For following tasks, please create a module in VA and build macros to finish these tasks. You must code it manually ( i .

Requirements: For following tasks, please create a module in VA 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 name(s) at the beginning of the module. Boldface the font of the label in cell A1, 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 A22 and boldface it; enter the label "Sum" in cell A23 and boldface it. 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 center 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 center 1. 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 =9085 score <9075 score <8565 score <75 below 65, do not change the font color. 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Knowledge Discovery In Databases

Authors: Gregory Piatetsky-Shapiro, William Frawley

1st Edition

0262660709, 978-0262660709

More Books

Students also viewed these Databases questions

Question

6. Describe why communication is vital to everyone

Answered: 1 week ago