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 |
|
| |
