Question: Create a dashboard sheet that allows you to look up a customer name ( on a drop down list ) and see their order information

Create a dashboard sheet that allows you to look up a customer name (on a drop down list) and see their order information (Output cells are: Order Date, Ship Date, Ship Mode, New City, State, Region, Category, Quantity, Discount, Total Sales, and New Order Number).

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 Databases Questions!

Q:

Data link: https://drive.google.com/drive/folders/1txHtl8_W2u1rUnGwdgDONyfg22KVKWUP?usp=sharing CAS 171 - Final Project: Computer Warehouse Data Files: ComputerWarehouse.accdb,...

Q:

I need help with the formulas from question 8 to 12. please and thank you. Part 2 - Data Validation and Formulas 8. In cell F6 and A14:A38 create data validation rules that allows you to choose the...

Q:

ERP Muesli manufactures cereal that they sell out of two manufacturing warehouses to three types of customers: 1) hypermarkets, 2) grocery chains, and 3) independent grocers. Until recently, all of...

Q:

ERP Muesli manufactures cereal that they sell out of two manufacturing warehouses to three types of customers: 1) hypermarkets, 2) grocery chains, and 3) independent grocers. Until recently, all of...

Q:

Problem 1 Web site topic: Your boss has asked you to create a web site for: a local community non-profit organization that sells rummage sale items. This week, they have asked you to set up 1 page to...

Q:

html5/Javascript/Css homework help. //////////////////////////////////////////////////////////////////////////////////////////// Problem 1 Web site topic: Your boss has asked you to create a web site...

Q:

Requirement 1 : The following articles will introduce you to the intersection of big data and the accounting profession. Even if you are working in groups, I expect EVERY STUDENT to read ALL of these...

Q:

P L U G - I N T3 Problem Solving Using Excel 2010 LEARN IN G OUT C O ME S 1. 2. 3. 4. 5. Describe how to create and sort a list using Excel. Explain why you would use conditional formatting using...

Q:

Please solve this Excel spreadsheet using the directions! Thank you so much! Directions: Excel Spreadsheet: The manager of Paco's Dog Treats, Inc. imported inventory data. This data must be cleansed....

Q:

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

Q:

Use this graph for Exercised 1 and 2. (a) Find the coordinates of points A, B, C, D, E, and F. (b) Find the coordinates of points G, H, I, J, K, and L. -5-4-3 21 1 2 3 4 5 x

Q:

What do managerial accountants mean when they speak of cost behavior? Why is it important in managerial decision making?

Q:

P 1 7 . 7 ( L 0 1 , \ ( \ underline { \ mathbf { 2 } } , \ underline { 3 } , 4 ) \ ) , AP Carleigh is the manager of the massage technicians at her chiropractic clinic. The owner / operator and...

Q:

i need correct answrrs 2 2 .

Q:

If the tax rate is 40 percent, compute the beforetax real interest rate and the after-tax real interest rate in each of the following cases. a. The nominal interest rate is 10 percent and the...

Q:

Assume that the reserve requirement is 20%. Also assume that banks do not hold excess reserves and there is no cash held by the public. The Federal Reserve decides that it wants to expand the money...

Q:

It is often suggested that the Federal Reserve try to achieve zero inflation. If we assume that velocity is constant, does this zero-inflation goal require that the rate of money growth equal zero?...