Excel Project 1
MKTG3808 - WEEK 1 PROJECT
| MKTG3808 - Prof. Hazari | |||||
| Order Date | Customer | Region | Sales Region | Units | |
| 1/2/18 | AAJA | Alaska | Pacific US | 735 | |
| 1/7/18 | BJAC | Germany | Europe | 1000 | |
| 1/12/18 | HIFI | Hawai'i | Pacific US | 3200 | |
| 1/17/18 | JCRI | Georgia | Atlantic US | 975 | |
| 1/19/18 | WIMC | Wisconsin | Central US | 716 | |
| 1/22/18 | WA4G | Washington | Pacific US | 4000 | |
| 1/23/18 | AU9S | Austria | Europe | 2000 | |
| 1/23/18 | MITA | Massachusetts | Atlantic US | 6275 | |
| 1/24/18 | MAPO | Massachusetts | Atlantic US | 1400 | |
| 1/31/18 | FL95 | Florida | Atlantic US | 1325 | |
| 2/1/18 | CASF | California | Pacific US | 1205 | |
| 2/2/18 | OHMY | Ohio | Central US | 7000 | |
| 2/4/18 | GAAT | Georgia | Atlantic US | 4000 | |
| 2/8/18 | TREX | Texas | Central US | 4900 | |
| 2/12/18 | PDOK | UK | Europe | 1765 | |
| 2/14/18 | BJAC | Germany | Europe | 200 | |
| 2/16/18 | CDFM | California | Pacific US | 1000 | |
| 2/22/18 | ILUI | Ohio | Central US | 1600 | |
| 2/23/18 | GAOM | Georgia | Atlantic US | 2000 | |
| 2/24/18 | AAJA | Alaska | Pacific US | 3000 | |
| 3/7/18 | MIMC | Michigan | Central US | 500 | |
| 3/8/18 | DMGR | Germany | Europe | 1700 | |
| 3/12/18 | AKFS | Alaska | Pacific US | 1800 | |
| 3/17/18 | NCST | North Carolina | Atlantic US | 1500 | |
| 3/28/18 | OKOK | Arkansas | Central US | 1350 | |
| 3/29/18 | FLMI | Florida | Atlantic US | 1700 | |
| 3/30/18 | ARKS | Arkansas | Central US | 3650 | |
| 4/2/18 | SWX2 | Switzerland | Europe | 1500 | |
| 4/7/18 | MAPO | Massachusetts | Atlantic US | 750 | |
| 4/9/18 | ATTX | Texas | Central US | 1000 | |
| 4/12/18 | SPTR | Hawai'i | Pacific US | 2100 | |
| 5/1/18 | SWX1 | Switzerland | Europe | 1600 | |
| 5/7/18 | HV11 | Switzerland | Europe | 2000 | |
| 5/9/18 | S2SC | Tennessee | Atlantic US | 2050 | |
| 5/9/18 | ORRC | Washington | Pacific US | 2100 | |
| ANSWER THE QUESTIONS GIVEN BELOW | ENTER HERE | ||||
| 1) What is the Total Number of Units sold from Jan to May? | |||||
| 2) What is the Average Number of units sold from Jan to May? | |||||
| 3) On how many days (count) were sales made? | |||||
| 4) On above sales days, what was the minimum number of units sold | |||||
| 5) On above sales days, what was the maximum number of units sold | |||||
| 6) What was the total number of units sold in Feburary | |||||
| 7) What was the average number of units sold in March | |||||
| 8) What percentage of sales were made in May? | |||||
| 9) How many unit sales were made in "Atlantic US" Sales region? | |||||
| 10) What percentage of total sales were made in Central US region? | |||||
| 11) On how many days were unit sales of more than 1500 made? | (Tip: Use COUNTIF formula) | ||||
| 12) On how many days were unit sales of less than 1000 units made? | (Tip: Use COUNTIF formula) |
Instructions: 1. The spreadsheet below provides Sales information for XYZ Company. The spreadsheet starts on cell C18. DO NOT CHANGE THIS! 2. Below the spreadsheet is where you will enter either a formula or function for each question. The answer will appear after you have entered a formula DO NOT ENTER A NUMBER. Each question is worth 2 points 3. Enter the Formula in the YELLOW HIGHLIGHTED cells only. Do not add any new data or any other cell 4. Save the spreadsheet as YOURLASTNAME_FIRSTINITIAL (e.g. SmithJ) and upload to Dropbox. Correct filname format will get you 1 point. Total points = 25