Question: Answer 2 , etc. How many sales did each salesperson sale on a Monday? What salespeople sold dryers? Include who they sold the dryer to
Answer etc.
How many sales did each salesperson sale on a Monday?
What salespeople sold dryers? Include who they sold the dryer to and on what date.
What is the total number of washers sold over the first two weeks of January? Hint: The first two weeks refer to between January st and th Also "total number" refers to washer units not numbers of sales. Some sales included more than one unit
Make a list of all the sales invoices having totals greater than $ also list what day of the week each invoice occurred on Make sure they are ordered by invoice total where the highest total is at the top.
Make a list of salespeople who made no sales on a Monday Hint: your answer to question is a good starting point
Import data from Access into Excel and make a pie chart showing the percent dollar sales for each product do not take color into account, so all of the washers, all of the dryers, etc. Include the Excel sheet with your submission.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
