7. Write (not record) a Macro, QUESTION7, that calculateemployees New Salary 2 in column L using the logic:

If an employee is working in a department whose name starts with letter A or has been with the company more than 15years, then her/his salary increases by 12%.

If however, the employee is not () working in a department whose name starts with letter A, and has been with the company between 5 and 15 years, s/he gets a salary increase by 8.5%.

In all other cases, salary remains the same. (Hint: Must use VBA/Macros IF and Do-Loop).

Create macro button in Database sheet

8. Write (not record) a Macro, QUESTION8, that will put the employees month of birth in column Birth Month, for each employee in the database. Month should be in text, e.g., March, May etc. (Hint: Must write VBA code from scratch). Create macro button in Database sheet.

9. Record a Macro, QUESTION9 to sort the database by age of employee (in descending order) within each Department, in ascending order. Be sure you dont sort a column independently of the records!!! Create macro button inDatabase sheet.

****PLEASE PROVIDE STEP BY STEP INSTRUCTIONS TO DO ON EXCEL

06 07 Q8 Age New Malary New Malaya Wish Math Emp ID 1011 1012 1041 1054 1055 Years is Service 21 15 Hire Date 200.00 1/2006 4/160 4/1600 Birth Date 11/21/64 12284 421/65 1937 820467 8/28/79 18 56 36 55 39 53 41 11 21 14 1075 49 21 12 BRRRRRR 50 19 27/06 1/21/00 1110 4/1001 4/1090 10 13.95 13/05 12/21/05 12/1103 10/2171 11/363 9/20/70 78/70 71278 10/1/66 9/1685 21 22 16 1152 1153 1167 1168 1169 1290 1299 1100 1101 1310 1311 1129 130 1331 15 35 55 9248 27 12 14 55 18 625661 1125 1154 5664 4254 521/64 107165 10/16 4258 Mary 56 52 56 55 55 2 57 57 11 22 21 25 22 35 16 31 1516 1517 1529 49 14 Last Name First Name Department Disse Garten Hal Accounting Capier Preston Lina Fagineering Primer Tercan Robert Rand D Printer Smith Howard An Copie Albert Maxine Marketing Copier Kane Sheryl An Primer Henders Mark Accounting Print Plant Alien Accounting Prima Berwick Sam Marketing Copier Asente Tel Engineering Fax Derberg Jeremy Engineering Copier Cooper Linda Admin Fax Simpan Sandrine Engineering Capier Richard Phillip Accounting Pri Sindele Randy Marketing Smith Engineering Cane Marketing Prime Vana Te Engineering Printer Selmick Anne Accounting Copier Cash Engineering Printer Socznyck Tadew Engineering Kansko Midori Rand D Fax Lampoline Pote Marketing Fax Bell Accounting Printer Quan Karen Engineering Printer Kellerman Tommi Engineering Printer Stewart Admin Printer Lempen Alexandra Rand D Copier Davison Karen Engineering Printer Balen Li Admin Copier Sargent Evelyn Marketing Copier Wells Rose Accounting Printer Ben Frank Accounting Fax Melendee Jaime Accounting Fax Miller Janel Marketing Copiel Wells Admin Copier Levine Eric Rand Fus Alain Isolde Engineering Fax Chu Steven Marketing Barton Eileen An Copier Alle Aaron Admin Fax Goldberg Malcolm Marketing Al-Sabah Dared Engineering Fax Lin Michael Engineering Fax Muller Ursula Accounting Copier Fontaine Accounting Copier Mueller Admin Fas Corwick Rob An Fax Felice Admin. Copiel Martinez Sam Marketing Capit Franklin Larry Accounting Copier Petry Robin Fagineering Printer Maguire Mollie An Copier Silverberg Jay Engineering Fax Salary $27.597.85 $43.394.15 528,043.68 $25.11.06 526.040.56 $23.239.44 526,645.20 $28.00.6 $31.913.88 $63,035.88 $58.002.05 S.,113.86 $34.854.20 530,4514 $27.98104 532.410.5 $43,486.95 555.410.25 S11.529.24 549.73.15 $99.162.20 $28,043.68 $64.689.00 $28.509.50 575.589,60 545.16. $35.146.68 541.683.48 529,362.20 $27.01.04 $41.987.40 $32.60 $27.597.35 529,645.34 $33,301.44 523.212.12 537.895.52 569.162.20 $28.000 528.859.25 $24.11.50 557.488.75 551,300.00 535,480.40 $16, 101.44 $28.043.61 $27.08104 $21.239.44 $23.212.32 $35.989.20 $21,867.95 $33L035.8% $30,013.62 551.878.84 4 30 24 14 1531 1556 1557 1958 1657 77763 9/10/11 1/15167 1/1967 92387 12290 9262 101023 1/17:30 1/2014 4 33 30 S8 37 11 IS 18 41 24 1675 1675 10-486 2003 2/22/09 21499 5/11/99 41695 4895 WS 1604 2/26/89 12.07 1/2091 5/11/96 11/2606 WIRD 10/1605 12/7602 325.06 1/17/96 1026.95 10/1001 11/607 8698 1/2997 12/24/07 12/1603 1NON 34492 7102 6/2009 11/13/92 11/5/06 11/1791 112901 11/93 5/7197 42901 300 1/5/05 1676 9/12/2 19 13 22 23 13 1677 1723 1724 1792 1793 1794 1814 1816 1931 1960 17 22:22 SEXUA2 28 57 SI 38 31 35 55 52 44 14 31 31 24 55 55 51 51 51 50 41 39 29 9/1689 9:23,165 521165 10 10/14/76 10/16 9/2869 9/1/89 526 12345 4/2651 51469 5795169 $19.50 28/70 10979 921781 10/1891 18 1961 KI 1966 1967 2x 14 20 29 2x Anda 1965 23 1975 1976 1977 19 20 1978 Create Macro buttons for Question 1 and Question 2 Be Macro Questions Criteria QI Put your answer in this cell Emp ID Last Name First Name Department Division Salary Hire Dale Birth Dan Transla Service New Salary 1 New Salary1 Birth Month 02 Put your answer in this cell Kep ID Last Name First Name Department Dlho Salary Nire Date Birth Dan Years in Senice New Salary New Salary: Birth Month Create Macro button for each question in "Database" worksheet