Question: 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

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

1 Expert Approved Answer
Step: 1 Unlock 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!