Question: Based on the information provided in the Excel workbook, answer the questions that follow. A B C D E F G H K Sales Data

 Based on the information provided in the Excel workbook, answer the

Based on the information provided in the Excel workbook, answer the questions that follow. A B C D E F G H K Sales Data for Month of April 2022 Sales Analysis 1 Sales Analysis 3 Product Customer Salesperson Sales Filter by Customer: Officeworks Filter by Sales greater than: $15,000 N W Headphones Officeworks David $14,758 Summary Frequency Total Sales Summary Frequency Total Sales Headphones Officeworks Robert $22,940 Desktops 2 $35,564 Amazon 2 $39,563 5 Laptops Amazon Robert $7,688 Headphones $85,412 JB Hifi $17,601 6 Headphones Officeworks Dennis $24,791 Laptops $5,006 Officeworks $146,299 7 Headphones Officeworks Robert $22,923 Speakers $40,081 PCGamer 2 $36,577 8 Speakers Officeworks Robert $16,718 Total $166,063 Total 12 $240,040 9 Desktops JB Hifi David $17,601 10 Headphones Amazon Dennis $20,644 Sales Analysis 2 Sales Analysis 4 11 Desktops Officeworks Edward $19,636 Filter by Salesperson: Dennis Filter by Sales less than: $10,000 12 Laptops Amazon Dennis $11,034 Summary Frequency Total Sales Summary Frequency Total Sales 13 Speakers JB Hifi David $8,553 Desktops 0 SO David 2 $17,012 14 Speakers Officeworks Edward $23,363 Headphones $45,435 Dennis SO 15 Laptops PCGamer David $16,175 Laptops $29,953 Edward $5,006 UI N NN 16 Headphones Amazon David $8,459 Speakers $20,402 Robert $7,688 17 Speakers JB Hifi Robert $14,987 Total $95,790 Total $29,706 18 Speakers PCGamer Dennis $20,402 19 Laptops Amazon Dennis $18,919 20 Desktops Officeworks David $15,928 21 Laptops Officeworks Edward $5,006

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!