$7)$ SUBTOTALS $-$ Create a Subtotal showing the total hours worked by department and the total overtime hours worked by gender within each department. Change to Outline View $3.[$Which department works the most hours and do you see something odd about the overtime hours?$]$ Copy the subtotal information to Sheet $2$ using Copy$/$Paste Special Values $($previously undisplayed$/$hidden data will appear when copied to Sheet $2).$

Remove the Subtotaling on Sheet $1$ using the Remove All button before continuing.

$8)$ GOAL SEEK $-$ In cell E$7,$ place a formula that will multiply the Overtime Rate $($B$3)$ by the Total Number of Overtime Hours. Perform a Goal Seek to determine the overtime rate necessary to achieve $$400$ in total overtime pay. Leave the goal seek in place so that it can be graded.

$9)$ EXTRACT $($Advanced Filter$)-$ Sort the database by the employees' names in ascending order. Extract just the name and the department number $($Dept$.$ No$.)$ of those who worked more than $8$ hours. Start the criteria in cell A$40$ and the extract output in cell A$44.$

$10)$ DATA TABLE $$ on SHEET $3$ create a One$-$Variable Data Table that will take the ODD numbers from $1$ to $55$ and will show each of the following independent calculations: multiply by $$6\mathrm{.}64$; divide by $3\mathrm{.}245$; add $$8\mathrm{.}23$ to each number; subtract $4$ from each number

I need help with the following steps.