Assignment 12-1

Assignment 12-1 - a. Click the EmpCounts tab. Click in the...

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

View Full Document Right Arrow Icon
INFS 3250 – Assignment 12 Analyze data in a PivotTable. Create a PivotTable. 1. Open EmpPivot and save it as [your initials] 20-20 . Display the PivotTable sheet. 2. Analyze data in a PivotTable by following these steps: a. Click cell B4. Click the PivotTable Tools Options tab. b. In the Active Field group, click the Field Settings button. c. Change the Custom Name to Female Employees . Click OK . d. Click cell C4 and repeat the steps to change the name to Male Employees . e. Click cell A4. Click the Options button in the PivotTable group. f. Click the Display tab. Click to deselect Display field captions and filter drop-downs . Click OK . g. Right-click cell A4 and choose Field Settings . On the Subtotals & Filters tab, choose Automatic . Click OK . h. Click the PivotTable Tools Design tab. Use Pivot Style Medium 15 . i. Click in the PivotTable Name box in the PivotTable group. Key PTSummary and press enter. 3. Insert page breaks at cells A20, A28, and A35. 4. Set rows 1:3 as print titles. Horizontally center the sheet. 5. Create a PivotTable by following these steps:
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: a. Click the EmpCounts tab. Click in the list. b. Click the Insert tab. Click the PivotTable button. c. Verify that the range is A3:F35 d. Click OK. e. In the Choose fields to add to report, click to select State . f. Click to select City. g. Click to select Students . It is placed as a Values field. h. Click cell B3. Click the Field Settings button. Change the Custom Name to Employees Who Are Students . i. Click cell A4. Click the PivotTable Tools Options tab. Click the Field Headers button to turn off field captions. j. Click the Field Settings button. On the Layout & Print tab, click to deselect Display subtotals at the top of each group . Click OK . k. Use Pivot Style Medium 15 . l. Click in the PivotTable Name box in the PivotTable group. Key StudentCount and press enter. 6. Copy the label in cell A1 on the PivotTable sheet to this sheet. Center the sheet horizontally. 7. Prepare and submit your work....
View Full Document

This note was uploaded on 12/03/2011 for the course INFS 3380 taught by Professor Ahmed during the Fall '11 term at Toledo.

Ask a homework question - tutors are online