Practice Activities

Lesson 2: Work Smarter, Not Harder

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. Sort the spreadsheet by Product in ascending order

3. Create a Group with the Detroit Agents

4. Hide the Detroit Agents.

5. Filter Products so only Coffee & Donuts are visible.

6. Use the Goal Seek function on John Cook (Northern Michigan Market).

   Set the value in column F to be $65,000 by changing the project income (Column E).

   Click OK to accept the Goal Seek.

7. Save this file as YOUR NAME Works Smarter Practice