Practice Activities Lesson 3: What Happened? (PivotTables) Before You Begin: Download the sample spreadsheet: Brown Bag Lunch Sales Team.xlsx.   Try This: Do the following steps 1. Open the spreadsheet: Brown Bag Lunch Sales Team.xlsx. 2. Go to Sheet 1. Select Row 1 and remove the Filters. 3. Select Sheet 1 and Insert a PivotTable on a New Worksheet. 4. Use the PivotTable Tools to Show the Field List. 5. Edit the PivotTable Field list as follows:    Select the Field: Market (It should be placed in the Row Labels, by default). 6. Drag the Field Sales to the Values (It should be placed in the Values as Count of Sales) .    Change Count of Sales to Sum of Sales. 7. Select the Field: Sales Agent (It should be placed in the Row Labels, by default). 8. Move the Field: Sales Agent from the Row Labels to the Column Labels. 9. Format Columns B:G for Accounting. 10. Save this as YOUR NAME What Happened Practice