I believe I'll need the formulas for on the time worked sheet, and can fill out the rest, and make the pivot tables.

Calculate the number of employees for each department. Which three departments have the highest salaries? You must cr3ate a pivot table with a pivot chart to support your answer. Which three employees are paid the most? You must cr3ate a pivot table with a pivot chart to support your answer. Which three departments paid the most in overtime? You must cr3ate a pivot table with a pivot chart to support your answer. Which three employees paid the most in overtime? You must cr3ate a pivot table with a pivot chart to support your answer. If you were sitting in a meeting with all department heads, cr3ate five questions that you would ask. Identify which department you direct the question to and the question you would ask.