Answered step by step
Verified Expert Solution
Link Copied!

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.

  1. a. Boldface the font of the label in cell A1, and change its font size to 14.
  2. b. Boldface and italicize the headings in row 3, and change their horizontal alignment to the right.
  3. c. Change the color of the font for the employee numbers in column A to light blue.
  4. d. Change the background (the interior property) of the range with scores to gray.
  5. e. Enter the label Averages in cell A22 and boldface it.
  6. 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

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

Intelligent Information And Database Systems Asian Conference Aciids 2012 Kaohsiung Taiwan March 2012 Proceedings Part 2 Lnai 7197

Authors: Jeng-Shyang Pan ,Shyi-Ming Chen ,Ngoc-Thanh Nguyen

2012th Edition

3642284892, 978-3642284892

More Books

Students also viewed these Databases questions

Question

Use a three-step process to develop effective business messages.

Answered: 1 week ago