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 60 5) On above sales days, what was the maximum number of units sold 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? ENTER HERE 73596 2102.742857 33 20 (Tip: Use COUNTIF formula) 6 Tip: Use COUNTIF formula) 68 69 70 71 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 60 5) On above sales days, what was the maximum number of units sold 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? ENTER HERE 73596 2102.742857 33 20 (Tip: Use COUNTIF formula) 6 Tip: Use COUNTIF formula) 68 69 70 71