$1.$ Copy the data worksheet to a new worksheet called Sort. Sort the employee list in

ascending order by department, then by last name, then by first name.

$2.$ Copy the data worksheet 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.$

$3.$ Copy the data worksheet to a new worksheet called Subtotal. Using the subtotal feature,

create a sum of the salary for each department.

$4.$ Copy the data worksheet 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.

Use the datasheet assigned to you by the lecturer and perform the above four tasks.

Record your video $($must show your face$)$ performing this lab using an appropriate tool $($e$.$g$.$

Zoom$),$ upload the video as private video on YouTube, and share the link alongside excel

sheet to Moodle.