Create a Macro using the Macro recorder and Visual Basic statements that will do the following: 1. Create a macro recording the advanced Filter for just those employees located in Chicago Create a form button for this macro and call it Chicago assign the short cut key Ctrl + Shift + c to the macro Add comments describing what this macro does in the VB window 2. Create a macro recording the advanced Filter for just those employees located in Atlanta Create a form button for this macro and call it Atlanta Assign the short cut key Ctrl + Shift+A to the macro Add comments describing what this macro does in the VB window 3. Create a macro recording the advanced Fater for ALL employees Create a form button for this macro and call it All Employees Assign the short cut key Ctrl + Shift + L to the macro Add comments describing what this macro does in the VB window 4. Create 2 macros: one that applies conditional formatting to those individuals who are managers and one that clears the conditional formatting Create 2 form buttons for the macros and call them Managers and ALL respectively Assign the short cut key Ctrl + Shift + M and Ctrl + Shift+K to the macros A B Location 1 Name 2 Adams Atlanta 3 Adamson Chicago 4 Brown Atlanta 5 Charles Boston 6 Coulter Atlanta Miami Miami 7 Elofson 8 Gillenson 9 James Chicago 10 Johnson Chicago 11 Manin Boston 12 Marder 13 Milgrom 14 Rubin 15 Smith 16 Name 17 18 19 20 21 22 Average Salary 23 Maximum Salary 26 27 28 Chicago Boston Manager Account Re Boston Atlanta Account Re Location 24 Minimum Salary 25 Total Salary C Title Trainee Manager Trainee Account Re Manager Account Re Manager Account Re Account Re Account Re Account Re Number of Employees Title D Service E Hire Date 27.4 11/24/93 29.1 3/16/92 27.4 11/24/93 29.1 3/16/92 27.4 11/24/93 28.4 10/31/92 $47,500 27.4 10/31/93 $55,000 31.4 10/31/89 $42,500 30.4 10/31/90 $47,500 29.1 3/16/92 $49,500 29.4 10/31/91 $38,500 29.1 3/16/92 $57,500 29.1 3/16/92 $45,000 27.4 11/24/93 $65,000 Service Hire Date Summary Statistics F Salary $19,500 $52,000 $18,500 $40,000 $100,000 Salary $48,429 $100,000 $18,500 $678,000 14 G