Question: With data in data.ws, Create a sub call manipulateObjects() with VBA Please also screenshot the code (A1)Technology Aptitude Test scores for employees of Digital Next

 With data in data.ws, Create a sub call manipulateObjects() with VBA

With data in data.ws, Create a sub call manipulateObjects() with VBA

Please also screenshot the code

(A1)Technology Aptitude Test scores for employees of Digital Next Company(/A1)
Employee Score1 Score2 Score3 Score4 Score5
1 90 87 76 95 86
2 78 90 99 84 84
3 72 60 84 58 69
4 82 66 81 69 72
5 95 85 82 77 93
6 90 93 66 88 93
7 90 100 57 70 89
8 90 98 61 56 83
9 96 67 85 56 97
10 87 69 77 78 76
11 81 68 61 66 93
12 58 57 72 75 77
13 70 92 59 99 85
14 69 71 89 68 72
15 85 94 66 78 67
16 55 79 99 98 76
17 60 75 63 67 90
18 83 93 88 58 56

Show transcribed image text

1. Consider the worksheet 'Data' in the attached workbook. a. For the worksheet title in column A1, do the following i. ii. iii. change the color of the text to Blue make the text bold set the text to uppercase. b. Underline the column headings in A3 through F3 (use single-underline, not double). c. Foreach of the cells in A4 through F21, format each cell per the table below Font Color Font T Blue Green Cyan Magenta Black Yellow Red Red Font Size Score 90-100 80 -89 70-79 60-69 50-59 40-49 30-39 20-29 Bold Bold Normal Normal italics talics Normal Normal 12 10 10 Thatis: If the score is between 90 and 100, then change the cells color to blue, set the font-size to 14 and make it bold, etc

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To create a VBA subroutine called manipulateObjects to format the worksheet as described follow thes... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!