Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Databases questions