Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. E61 1350 3/28/19 OKOK 3/29/19 FLMI Central US Arkansas 43 Atlantic US Central US 1700 Florida 44 3650 3/30/19 ARKS 4/2/19 SWX2 4/7/19 MAPO Arkansas 45 1500 Switzerland Europe 46 750 Massachusetts Atlantic US 47 1000 Central US Pacific US 4/9/19 ATTX 4/12/19 SPTR 5/1/19 SWX1 Texas 2100 Hawai 49 1600 Switzerland Europe Europe 50 2000 5/7/19 HV11 5/9/19 S2sc 5/9/19 ORRC Switzerland 51 2050 Tennessee Atlantic US 52 2100 Washington Pacific US 53 54 ENTER HERE 73596 2102.742857 33 55 ANSWER THE QUESTIONS GIVEN BELOW 56 1) What is the Total Number of Units sold from Jan to May? 57 2) What is the Average Number of units sold from Jan to May? 58 3) On how many days (count) were sales made? 59 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 60 61 6) What was the total number of units sold in Feburary 62 7) What was the average number of units sold in March 63 8) What percentage of sales were made in May? 64 9) How many unit sales were made in "Atlantic US Sales region? 65 10) What percentage of total sales were made in Central US region? 66 11) On how many days were unit sales of more than 1500 made? 67 12) On how many days were unit sales of less than 1000 units made? 68 20 mp: Use COUNTIF formula) 6 Tip: Use COUNTIF formula) 69 70 71 72 73 MKTGSDOB WEEK1 PROJECT Ready MacBook esc F3 F4 2$ #3 3 6