5) CHART - Create a 3-D pie chart showing the breakdown of totalHours Worked into total Overtime Hours and the NonOvertime hourslocated at the bottom of the database listing, row 37 columns E, F,G. The pie chart should show the values, the legend should indicateOvertime Hours and NonOvertime, and the chart title should be TotalDaily Hours. Place this chart so that it will fill cells K1:R16.(Hint: When selecting the data for this chart remember that piecharts show parts of a whole so there’s no reason to include atotal if you are displaying the parts making up that total.) [Inspreadsheets, does it make sense to put totals at the bottom of thedatabase?] 6) DATA TABLE - Create a Data Table that shows theaverage Daily Pay by gender for each department number. Start thecriteria in cell E40 and the data table in cell E44. 7) SUBTOTALS -Create a Subtotal showing the total hours worked by department andthe total overtime hours worked by gender within each department.Change to Outline View 3. [Which department works the most hoursand do you see something odd about the overtime hours?] Copy thesubtotal information to Sheet 2 using Copy/Paste Special Values(previously undisplayed/hidden data will appear when copied toSheet 2). Remove the Subtotaling on Sheet 1 using the Remove Allbutton before continuing. 8) GOAL SEEK - In cell E7, place aformula that will multiply the Overtime Rate (B3) by the TotalNumber of Overtime Hours. Perform a Goal Seek to determine theovertime 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 inascending order. Extract just the name and the department number(Dept. No.) of those who worked more than 8 hours. Start thecriteria in cell A40 and the extract output in cell A44. 10) DATATABLE – on SHEET 3 create a One-Variable Data Table that will takethe 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.
