| Veggie Spot | ||||||
| Providing Great Veggie Sandwiches for All! | ||||||
| 1999 Revenue by Product | ||||||
| Item | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Product Total | |
| Crispy Tofu | $2,700 | $2,900 | $1,500 | $1,200 | ||
| Grilled Veggie | $1,200 | $2,500 | $2,700 | $3,200 | ||
| Herbed Tofu | $1,500 | $1,400 | $2,000 | $1,900 | ||
| Hummus Pita | $2,500 | $3,500 | $4,400 | $4,100 | ||
| Marinated Portabella | $3,500 | $4,500 | $5,100 | $3,700 | ||
| Marinated Tofu | $2,000 | $2,100 | $2,100 | $2,000 | ||
| Peanut Butter & Sprouts | $4,000 | $6,000 | $7,500 | $5,500 | ||
| Spicy Black Bean Spread | $3,700 | $4,500 | $4,300 | $5,500 | ||
| Veggie Pita | $2,900 | $3,700 | $3,100 | $3,300 | ||
| Quarter Totals | ||||||
| Download Excel Template | ||||||
| Instructions | ||||||
| Copy and paste above information into Excel | ||||||
| Save the file as VEGGIE2 | ||||||
| Using the SUM function-find the Product Total and the Quarter Totals | ||||||
| Format the totals for currency | ||||||
| Select cells A1-A2: Change font to 18-point-Bernard MT Condensed | ||||||
| Wrap text for cells A1-A2 | ||||||
| Select A4-Change font to 12-point Bernard MT Condensed | ||||||
| Select A6-Change font to 12-point Arial, Bold | ||||||
| Wrap text for cells in Row 6-Center contents in cell-Adjust width of column so text wraps | ||||||
| Format Quarter Totals with 12-point Arial Bold | ||||||
| Email completed spreadsheet to | pstephan@nuhsd.k12.ca.us | |||||