Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 5 . Use the Advanced Filters worksheet to complete the following: a . Filter for orders with an Order Date between February 1 ,
Use the Advanced Filters worksheet to complete the following:
a Filter for orders with an Order Date between February and March inclusive.
Display Extract fields of Order Date, Customer and Quantity. Use N: for Criteria. Use N:P for Extract. Widen columns to show all data.
b Filter for customers who are in Lakefield or Hastings with sales between $ and $ inclusive. Extract fields for Customer, Sales, Category and City. Sort the extracted City AZ Use S:U for Criteria. Use :V for Extract. Widen columns to show all data.
c Filter for customers who ordered more than beverages or customers who ordered more than sauces. Extract fields for Customer, Category, Quantity and Order Date. Sort the extracted Category. Use X:Y for Criteria. Use X:AA for Extract. Widen columns to show all data.
Select the Documentation sheet.
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