excel test

Expert Software Company
Salesperson	Total Sales	Base Salary	Commission	Total Salary	Salesperson's Evaluation
Adams, John	$98,000	$35,000
Barber, Maryann	$24,000	$35,000
Boone, Dan	$39,000	$50,000
Borow, Jeff	$56,000	$35,000
Brown, James	$81,000	$50,000
Carson, Kit	$17,000	$50,000
Coulter, Sara	$22,000	$35,000
Fegin, Richard	$72,000	$35,000
Ford, Judd	$64,000	$35,000
Glassman, Kris	$25,000	$35,000
Goodman, Neil	$70,000	$50,000
Milgrom, Marion	$11,000	$50,000
Moldof, Adam	$68,000	$50,000
Smith, Adam	$100,000	$50,000
		Average Total Salary
		Highest Total Salary
		Lowest Total Salary
Commission Percentages				Evaluation Criteria
Total Sales < $50,000	3%			$0	Poor
Total Sales ≥ $50,000	4%			$25,000	Fair
Commisson Threshold	$50,000			$50,000	Good
				$75,000	Excellent