I need help with questions 1-10.

1) CONDITIONAL FORMATTING - Add conditional formatting to theHours Workedfield data so that any hours worked greater than 8 will show in white font with a dark fill.

2) DATABASE FUNCTION - Create a database function in cell E5 that calculates the average hours worked by males in Dept. No. 2.If criteria are needed, start in cell E1.

3) VLOOKUP - In theDepartmentfield (column D) use the VLOOKUP function to place the appropriate department names in theDepartmentfield for each employee.Begin the table in cell H1.Dept. No. 3 is Computer; Dept. No. 2 is Sales; and Dept. No. 1 is Manufacturing.

4) IF - In theDailyfield use the IF function to indicate the wordOvertimeif the hours worked is greater than 8, the wordNoneif the hours worked is zero, and if the hours worked is greater than zero but8 or lessmultiplythe number ofhours workedby thehourly rate in cell B2.Copy this formula down theDailycolumn for each employee.

5) CHART - Create a 3-D pie chart showing thebreakdownof totalHours Workedinto totalOvertime Hoursand theNonOvertimehours located at the bottom of the database listing, row 37 columns E, F, G.The pie chart should show the values, the legend should indicateOvertime HoursandNonOvertime,and the chart title should beTotal Daily Hours.Place this chart so that it will fill cells K1:R16.(Hint:When selecting the data for this chart remember that pie charts showparts of a wholeso there's no reason to include a total if you are displaying the parts making up that total.)[In spreadsheets, does it make sense to put totals at the bottom of the database?]

6) DATA TABLE - Create a Data Table that shows the averageDaily Payby 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 toSheet 2using Copy/Paste Special Values (previously undisplayed/hidden data will appear when copied to Sheet 2).

Removethe Subtotaling onSheet 1using theRemove Allbutton before continuing.

8) GOAL SEEK - In cell E7, place a formula that will multiply theOvertime Rate(B3) by theTotal 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 - onSHEET 3create a One-Variable Data Table that will take the ODD numbers from 1 to 55 and will show each of the followingindependent calculations:multiply by $6.64; divide by 3.245; add $8.23 to each number; subtract 4 from each number.