Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Make sure you place a button on the worksheet to run every subroutine of the required tasks. Put all items below in a subroutine. Write
Make sure you place a button on the worksheet to run every subroutine of the required tasks. Put all items below in a subroutine. Write the code, don't record a macro. 1. Use VBA to name the following ranges with the specified name: cell A1 as Title, Boldface the font of the label in the Title cell, and change its font size to 16. Merge cell range A1:E1 and center the text. 2. Use VBA to name the following ranges with the specified name: the headings in row 3 as Headings, the students sequence in column A as Students. 3. Sort Exam 3 column in ascending form, then name the cells D3:D18 as column 3 , and do the following on the fonts of this range: bold, italic, size 12, and green color . 4. Sort Exam 1 column in descending form, then name the cells B3:B18 as column 1, and do the following on the fonts of this range: bold, italic, size 12 , and red color. 5. Write a new subroutine to clear all the changes done on the original Data worksheet. Place a button in the worksheet to run this subroutine. Note You have to use Button(s) on worksheet(s) to run the task(s) in this lab and all next labs. Marks will be deducted if you do not use buttons. Exam scores \begin{tabular}{|l|r|r|r|r|} \hline Name & Exam 1 & Exam 2 & Exam 3 & Exam 4 \\ \hline Chaney & 67 & 90 & 93 & 76 \\ \hline Donaldsor & 92 & 66 & 61 & 94 \\ \hline Babcock & 95 & 96 & 88 & 71 \\ \hline Pratt & 65 & 73 & 73 & 100 \\ \hline Abbott & 96 & 64 & 67 & 78 \\ \hline Hill & 75 & 77 & 100 & 90 \\ \hline Smith & 76 & 98 & 71 & 97 \\ \hline Emory & 68 & 75 & 66 & 74 \\ \hline Fishback & 78 & 66 & 55 & 66 \\ \hline Tyson & 86 & 90 & 80 & 90 \\ \hline Manson & 93 & 69 & 95 & 95 \\ \hline Lemonds & 61 & 96 & 83 & 69 \\ \hline Rivers & 90 & 79 & 84 & 77 \\ \hline Woods & 99 & 89 & 91 & 60 \\ \hline Grant & 90 & 60 & 60 & 72 \\ \hline \end{tabular}
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