q5 - drop the Salary field a second time in the table...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
5 Use the PivotTable tool to determine the sum of salary and the average salary for each job Title in each Clearance category. Also, show the total salary and average salary for each Title and again for each Clearance category. The layout of the PivotTable is shown below. Place the PivotTable in a new worksheet and name the worksheet Problem #5 . The way to add the Average of Salary summary data in addition to the Sum data into the PivotTable is to drag-and-
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: drop the Salary field a second time in the table template. Next, go to the Field Settings of this field and change the Summarize by tab and choose the appropriate summary function. State in the Word document which Titles in which Clearance categories have the top two average salary amounts. Add the PivotTable in the document. ANSWER:...
View Full Document

Ask a homework question - tutors are online