Answered step by step
Verified Expert Solution
Link Copied!

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 ,

15. Use the Advanced Filters worksheet to complete the following:
a. Filter for orders with an Order Date between February 1,2022 and March 31,2022 inclusive.
Display (Extract) fields of Order Date, Customer and Quantity. Use N4:06 for Criteria. Use N8:P8 for Extract. Widen columns to show all data. (4)
b. Filter for customers who are in Lakefield or Hastings with sales between $600.00 and $2000.00 inclusive. Extract fields for Customer, Sales, Category and City. Sort the extracted City A-Z. Use S4:U6 for Criteria. Use 58:V8 for Extract. Widen columns to show all data. (4)
c. Filter for customers who ordered more than 5 beverages or customers who ordered more than 20 sauces. Extract fields for Customer, Category, Quantity and Order Date. Sort the extracted Category. Use X4:Y6 for Criteria. Use X8:AA8 for Extract. Widen columns to show all data. (4)
16. Select the Documentation sheet. (1)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cybersecurity In Finance

Authors: Sylvain Bouyon, Simon Krause

1st Edition

1786612178, 9781786612175

Students also viewed these Databases questions