3. chapter 8 (30 points)
a. name the worksheet for this problem: week 3
b. week 1 should keep track of sales for the week
i. have one row for each day: wednesday, thursday, and friday (the
company is closed the rest of the week)
ii. have columns for the user to input the number of units sold and the selling
price per unit for each day
iii. add an additional column that calculates the total sales revenue for each
day
iv. input the following data:
1. monday: sold 100 units; selling price is $15 per unit
2. tuesday: sold 200 units, selling price is $10 per unit
3. wednesday: sold 3,000 units; selling price is $5 per unit
c. create a copy the week 3 worksheet to the right of week 3
i. rename the copy as: week 4
ii. input the following data for week 4:
1. monday: sold 500 units, selling price is $9 per unit
2. tuesday: sold 100 units; selling price is $15 per unit
3. wednesday: sold 50 units, selling price is $20 per unit
d. create a third worksheet for this problem named: report
i. create a report that calculates and displays the following information:
1. the total revenue for week 3
2. the total revenue for week 4
3. the total number of units sold for the two week period
4. the average selling price per unit for the two week period