Copy the worksheet Data to a new worksheet called Sort. Sort the employee list in ascending order by department, then by last name, then by first name.
Copy the worksheet Data to a new worksheet called Autofilter. Using the Autofilter feature, create a custom filter that will display employees whose birth date is greater than or equal to 1/1/1965 and less than or equal to 12/31/1975.
Copy the worksheet Data to a new worksheet called Subtotal. Using the subtotal feature create a sum of the salary for each department.
Copy the worksheet Data to a new worksheet called Formatting. Using the salary column, change the font color to red if the cell value is greater than or equal to 55000. You must use the conditional formatting feature to complete this step.