chap5_case_law_solution - Open the Student File:...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Open the Student File: chap5_case_law. 2. Save the file as chap5_case_law_solution. 3. Sort the List STEPS: To sort a list by three levels: Click anywhere in the list of lawyers, click the Data tab, and click Sort in the Sort and Filter group to open the Sort dialog box. Click the Sort by drop-down arrow and click Last Name. Click the Add Level button. Click the Then by drop-down arrow and click First Name. Click the Add Level button. Click the Then by drop-down arrow and click City. Click OK to sort the list by last and first name and then by city. 4. Create a Pivot Table STEPS: To create a Pivot Table: Click anywhere in the list of lawyers, click the Insert tab, and click PivotTable in the Tables group to open the Create PivotTable dialog box. Verify that the Select a table or range is selected and that the Table/Range is Lawyers! $A$5:$G$87. Verify that New Worksheet is selected and click OK. Drag the Specialty field to the Row Labels area. Drag the City field to the Column Labels area Drag the Gender field to the Report Filter area. Drag the Last Name field to the Values area. Double-click the Sheet1 tab (the worksheet that contains the PivotTable), type PivotTable as the new name, and press Enter. NOTE: The Pivot Table shows the number of lawyers in each specialty by the city where they are located. The filter is by gender but is set to both M and F, but could show only one or the other by selecting one from the drop down box. The Pivot Table counts the number of names in each category. 5. Create a Pivot Chart STEPS: To create a
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/18/2009 for the course BUSINESS CSIT126 taught by Professor Dfaad during the Spring '09 term at Aarhus Universitet.

Page1 / 2

chap5_case_law_solution - Open the Student File:...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online