Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write a single sub in the Employee_Scores.xlsx file and use VBA to declare and set the following Range object variables: cell A1 as titleCell, the
Write a single sub in the Employee_Scores.xlsx file and use VBA to declare and set the following Range object variables: cell A1 as titleCell, the headings in row 3 as headingRange, the employee numbers in column A as empNumbersRange, and the range of scores as scoresRange. Refer to these object variables as you code parts a f below.
- a. Boldface the font of the label in cell A1, and change its font size to 14.
- b. Boldface and italicize the headings in row 3, and change their horizontal alignment to the right.
- c. Change the color of the font for the employee numbers in column A to light blue.
- d. Change the background (the interior property) of the range with scores to gray.
- e. Enter the label Averages in cell A22 and boldface it.
- f. Enter a formula in cell B22:F22 that averages the scores above it.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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