, you have customer data retrieved from 3 tables and stored in 3 different worksheets. Customer personal information in Customer worksheet, results of promotion in Promotion, and data about the customer car in Car worksheet.

You are going to create a sampling tool for data analysis. This is a worksheet where you enter the customer ID for automatic retrieval of customer data from the other 3 worksheets.

Work in Information worksheet. Create formulas in columns B through S to retrieve each customers data by entering customer ID in the same row, column A. You should be able to enter formulas only in the first row and copy them down in columns.

Use the current workbook configuration. Do not move the data from their worksheet into one table. You have to look up data from all three worksheets.

Create named ranges to address data fields. This will make the process easier and less error-prone.

• Customer Tab: A2:H1437 - Customer_Data
• Promotion Tab: A2:C1437 - Call_Info
• Car Tab: A2:J1437 - Car_Info

Create a drop-down list for CustomerID. Test your work by creating a sample of 14 customers. Enter customer IDs of 100, 200, 1400 for demonstration.

Rubric:

Item	Points
Named ranges created	.5
CustomerID Drop-Down List Created	.5
All 18 functions work properly and retrieve the customer data (0.5 point each)	9
Total	10