Excel Project 1
ANSWER THE QUESTIONS IN EXCEL CHART
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?
12) On how many days were unit sales of less than 1000 units made?