Please help!!

6) DATA TABLE - Create a Data Table that shows the average Daily Pay by gender for each department number. Start the criteria in cell E40 and the data table in cell E44.

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 E7, place a formula that will multiply the Overtime Rate (B3) 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 A40 and the extract output in cell A44.

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.64; divide by 3.245; add $8.23 to each number; subtract 4 from each number.

				Gender	Dept No		1	Manufacturing
Hourly Rate:	$ 6.64			M	2		2	Sales
Overtime Rate:	$ 11.11						3	Computer
Average Hours Worked by Males in Dept No 2:				5.4
Total Number of Overtime Hours:				36
		Total Overtime Pay:		$ 400.00
Employees	Gender	Dept No	Department	Hours Worked	Overtime Hours	NonOvertime	Daily	Daily Pay
Adkins, Dorinda	F	2	Sales	0	0	0	NONE	$ -
Boucher, Leslie	F	3	Computer	9	1	8	OVERTIME	$ 64.23
Carman, Nancy	F	2	Sales	7	0	7	46.48	$ 46.48
Clayton, Rex	M	1	Manufacturing	12	4	8	OVERTIME	$ 97.56
Crenshaw, Sheila	F	1	Manufacturing	10	2	8	OVERTIME	$ 75.34
Darrell, Bailey	M	2	Sales	4	0	4	26.56	$ 26.56
Denton, Susie	F	1	Manufacturing	9	1	8	OVERTIME	$ 64.23
Diffee, Kois	F	3	Computer	6	0	6	39.84	$ 39.84
Hall, Mike	M	2	Sales	5	0	5	33.2	$ 33.20
Hammons, Larry	M	1	Manufacturing	6	0	6	39.84	$ 39.84
Hill, Joy	F	1	Manufacturing	10	2	8	OVERTIME	$ 75.34
Hill, Peggy Joan	F	3	Computer	9	1	8	OVERTIME	$ 64.23
Huntington, Mike	M	2	Sales	7	0	7	46.48	$ 46.48
Lee, Tammy	F	3	Computer	7	0	7	46.48	$ 46.48
Pierce, Sammy	M	3	Computer	13	5	8	OVERTIME	$ 108.68
Pierson, Tony	M	1	Manufacturing	11	3	8	OVERTIME	$ 86.45
Savoie, Tony	M	3	Computer	9	1	8	OVERTIME	$ 64.23
Shelton, Kent	M	1	Manufacturing	8	0	8	53.12	$ 53.12
Smith, Brian	M	3	Computer	12	4	8	OVERTIME	$ 97.56
Stull, Marlene	F	3	Computer	0	0	0	NONE	$ -
Tibbetts, Rusty	M	2	Sales	8	0	8	53.12	$ 53.12
Trice, Ricky	M	3	Computer	14	6	8	OVERTIME	$ 119.79
Webb, Patsy	F	2	Sales	8	0	8	53.12	$ 53.12
Webb, William W.	M	1	Manufacturing	11	3	8	OVERTIME	$ 86.45
White, Bill	M	3	Computer	11	3	8	OVERTIME	$ 86.45
Whitehead, Bobby	M	2	Sales	3	0	3	19.92	$ 19.92
				209	36	173		$ 1,548.72
Employee	Dept. No.
>8
				Department	Gender	Average Daily Pay
				1	M	72.68622222
				1	F	71.63851852
				2	M	35.856
				2	F	49.8
				3	M	95.34222222
				3	F	37.63777778