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. (Hint:Use the Filter to show ONLY the Detroit Agents.)
4. Hide the Detroit Agents.(Hint:Use the Filter to show everyone BUT 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 Increase (Column E).
Click OK to accept the Goal Seek.
7. Save this file as YOUR NAME Works Smarter Practice. |
|
| |
