Lab: Excel 2
Sam1
ExcelP2SalesReport1.xlsxSalesReport
| Quarterly Sales Report | |||||||
| Rep Name | Sales | Gross Profits | Expenses | Net Profits | Commission | ||
| George Bush | 44,000 | 1,440 | |||||
| Bill Clinton | 108,000 | 1,650 | |||||
| Ron Reagan | 69,000 | 800 | |||||
| Jim Carter | 95,500 | 600 | |||||
| Total Sales | |||||||
| Average | |||||||
| Lowest | |||||||
| Highest | |||||||
| Profit Margin | 35% | ||||||
| Comm % | 10% |
Charts
| Mountie Enterprises Sales Chart |
