Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What is the total order quantity for customers who are buying either tables (i.e. any kind of tables) or computer desk? [DSUM] What was the
- What is the total order quantity for customers who are buying either tables (i.e. any kind of tables) or computer desk? [DSUM]
- What was the minimum order quantity for orders placed by companies in New Jersey (NJ) or California (CA), and with order dates between 2/01/2011 and 4/30/2012, both dates inclusive? [DMIN]
- What is the total order quantity for Scandinavian desks with smooth finish? [DSUM]
Lone Pine Furniture (LPF) Database | Sales Tax Percentage | 9.50% | ||||||||||||||||||||||||||||
Q1 | Q1 | Q1 | Q2 | Q8 | Q15 | BONUS | ||||||||||||||||||||||||
Customer ID | Order Number | Customer Name | State | Customer Since | Order Date | Product Line Name | Product Finish | Product Description | Order Quantity | Selling Price | Total Order Amount | Sales Tax | Final Order with tax | Product Category | Discounted Selling Price | Shipment Date | Discount Applicable | |||||||||||||
C1 | 9 | American Euro Lifestyles | NJ | 3/6/10 | 3/16/12 | Cherry Tree | Cherry Gold, Antique | End Table | 44 | $175.00 | ||||||||||||||||||||
C1 | 16 | American Euro Lifestyles | NJ | 3/6/10 | 1/9/12 | Scandinavia | Natural Oak, Aged | Coffee Table | 8 | $225.00 | ||||||||||||||||||||
C2 | 10 | Battle Creek Furniture | MI | 5/5/10 | 3/6/12 | Country Look | Walnut Brown, Speckled | Computer Desk | 27 | $325.00 | ||||||||||||||||||||
C2 | 7 | Battle Creek Furniture | MI | 5/5/10 | 2/5/12 | Scandinavia | Natural Ash, Smooth | Computer Desk | 45 | $375.00 | ||||||||||||||||||||
C3 | 5 | California Classics | CA | 1/3/11 | 1/23/12 | Scandinavia | Natural Ash, Aged | Computer Desk | 35 | $375.00 | ||||||||||||||||||||
C4 | 14 | Contemporary Casuals | FL | 5/5/10 | 2/21/12 | Scandinavia | Natural Elm, Smooth | Coffee Table | 15 | $225.00 | ||||||||||||||||||||
C4 | 6 | Contemporary Casuals | FL | 5/5/10 | 2/15/12 | Cherry Tree | Cherry Gold, Antique | End Table | 30 | $175.00 | ||||||||||||||||||||
C4 | 8 | Contemporary Casuals | FL | 5/5/10 | 1/17/12 | Country Look | Natural Maple, Stained | Entertainment Center | 18 | $650.00 | ||||||||||||||||||||
C4 | 13 | Contemporary Casuals | FL | 5/5/10 | 1/9/12 | Country Look | Walnut Gold, Aged | Computer Desk | 20 | $675.00 | ||||||||||||||||||||
C1 | 17 | Eastern Furniture | NJ | 4/15/10 | 2/13/12 | Scandinavia | Natural Mahogany, Smooth | Dining Table | 25 | $900.00 | ||||||||||||||||||||
C5 | 18 | Eastern Furniture | NJ | 4/15/10 | 1/2/12 | Country Look | Natural Maple, Blocked | Entertainment Center | 26 | $700.00 | ||||||||||||||||||||
C6 | 12 | Home Furnishings | NY | 10/17/10 | 1/26/12 | Country Look | Natural Maple, Smooth | Entertainment Center | 23 | $735.00 | ||||||||||||||||||||
C7 | 4 | Impressions | CA | 4/25/10 | 1/3/2012 | Scandinavia | White Ash, Aged | 8-Drawer Desk | 22 | $750.00 | ||||||||||||||||||||
C7 | 15 | Impressions | CA | 4/25/10 | 3/14/12 | Country Look | Walnut Espresso, Crackled | Computer Desk | 62 | $250.00 | ||||||||||||||||||||
C8 | 11 | Mountain Scenes | UT | 10/17/12 | 3/18/12 | Scandinavia | Natural Ash, Smooth | Computer Desk | 35 | $375.00 | ||||||||||||||||||||
C9 | 1 | Value Furniture | TX | 10/10/12 | 1/3/2012 | Country Look | Natural Maple, Smooth | Entertainment Center | 29 | $750.00 | ||||||||||||||||||||
C9 | 2 | Value Furniture | TX | 10/10/12 | 1/3/2012 | Cherry Tree | Cherry Rust, Antique | Writers Desk | 42 | $325.00 | ||||||||||||||||||||
C9 | 3 | Value Furniture | TX | 10/10/12 | 2/13/12 | Scandinavia | Natural Ash, Aged | Dining Table | 13 | $800.00 | You MUST set up all your criteria for following questions on this "Queries" sheet! | |||||||||||||||||||
Except for Questions number 8, 9 and 15 (presented below), make use of criteria range provided for other questions in this QUERIES sheet | ||||||||||||||||||||||||||||||
Provide your Excel formula/function in the box provided for each question | ||||||||||||||||||||||||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started