Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates 53 x fx 3/30/19 ARS 4/2/19 SW 4/1/19 MAPO 4/9/19 ATTX 4/12/19 SPTR 5/1/19 SWX1 5/7/19 HV11 5/9/19 525C 5/9/19 ORRC Arianas Switzerland Massachusetts Texas H awai' Switzerland Switzerland Tennessee Washington Central USH! Europe Atlantic US Central US Padfic US Europe Europe Atlantic US Pacific US 3650 1500 750 1000 2100 1600 2000 2050 2100 ENTER 73596 5 ANSWER THE QUESTIONS GIVEN BELOW 5 1) What is the Total Number of Units sold from Jan to May? 12] What is the average Number of units sold from Jan to May? S 3) On how many days (count) were sales made? 194) On above sales days, what was the minimum number of units sold 05) On above sales days, what was the maximum number of units sold 516) What was the total number of units sold in Feburary 32 7) What was the average number of units sold in March 63 B) What percentare of sales were made in May? 54 9) How many unit sales were made in "Atlantic US" Sales rerion? 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? mp: Use COUNTIF formule) Tip: Use COUNTIF formula) MKTGEWEEXPROTEC Enter MacB 000 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates 53 x fx 3/30/19 ARS 4/2/19 SW 4/1/19 MAPO 4/9/19 ATTX 4/12/19 SPTR 5/1/19 SWX1 5/7/19 HV11 5/9/19 525C 5/9/19 ORRC Arianas Switzerland Massachusetts Texas H awai' Switzerland Switzerland Tennessee Washington Central USH! Europe Atlantic US Central US Padfic US Europe Europe Atlantic US Pacific US 3650 1500 750 1000 2100 1600 2000 2050 2100 ENTER 73596 5 ANSWER THE QUESTIONS GIVEN BELOW 5 1) What is the Total Number of Units sold from Jan to May? 12] What is the average Number of units sold from Jan to May? S 3) On how many days (count) were sales made? 194) On above sales days, what was the minimum number of units sold 05) On above sales days, what was the maximum number of units sold 516) What was the total number of units sold in Feburary 32 7) What was the average number of units sold in March 63 B) What percentare of sales were made in May? 54 9) How many unit sales were made in "Atlantic US" Sales rerion? 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? mp: Use COUNTIF formule) Tip: Use COUNTIF formula) MKTGEWEEXPROTEC Enter MacB 000