Question
6) DATA TABLE - Create a Data Table that shows the average Daily Pay by gender for each department number. Start the criteria in cell
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. 11) Put your name in the Header and submit your file (instructors flash drive or Blackboard). 12) If required by your instructor, print the Sheet 1 worksheet (including chart) landscape orientation, showing the worksheet frame (row & column headings), fit-to-one page. If required, print the contents of Sheet 2 and Sheet 3. Need Help with the last 6 steps
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started