EXCEL EXERCISE #2

profileMaldiyvormbn
ExcelProject2.xlsx

Sales

Region Code Region
Date 10 East Coast
Sales Goal $ 250,000.00 20 Mid West
30 West Coast
40 International
2015 Sales Total By Quarter
Sales Rep Q1 Q2 Q3 Q4 Total Region Code Region Status
Billy 29911 92249 46475 33947 40
Randy 32752 30222 43997 93277 40
Mike 36991 54102 63914 42642 20
Jill 50087 25179 64912 68875 20
Lamar 52923 62673 63635 57410 10
Sang 59678 70934 78410 32994 10
Swathi 66385 74270 36165 76548 30
Larry 66936 72838 60479 63324 30
Rick 74507 94178 41391 27235 10
Rich 76889 49266 64225 55410 30
Jill 90515 29238 30973 32145 10
John 97426 43061 26122 83391 10
Greg 98094 47398 80755 40446 40
Summary
Median Sales
Average Sales Dollar Amount
Total Number of Sales Reps