Question: I don't understand how to create the validation list or where to insert the VLOOKUP. Please submit the solution and how you found it. OUTCOMES-BASED

I don't understand how to create the validation list or where to insert the VLOOKUP. Please submit the solution and how you found it.I don't understand how to create the validationI don't understand how to create the validationI don't understand how to create the validation

OUTCOMES-BASED ASSESSMENTS Apply a combination of GO! Think Project 4L Key Chains the 1A and 1B skills. PROJECT FILES For Project 4L, you will need the following file: e04L_Key_Chains You will save your workbook as: Lastname_Firstname_4L_Key_Chains From your student files, open the file e04L_Key_Chains, and then save it in your chapter folder as Lastname_Firstname_4L_Key_Chains So that order takers do not have to type the Style Code, Description, and Unit Price in the Order Form worksheet, use the information on the Product Information sheet to create a validation list for the Item and then insert a VLOOKUP function in the Description and Unit Price columns. Then create an order for two of the Plush Animal Key Chains (K-S) and two of the Classic Key Chains (M-TF). Delete unused rows, create appropriate totals, apply financial formatting, and then save and submit it as directed. END You have completed Project 4L 4A B E F D Jesse Jewelers Order Form 4 Customer Name 5 Customer Number 6 Order Date Peterson Travel Accessories, Inc. RS-1118 21-Oct 7 8 Item Description Quantity Unit Price Order Amount Total: Order Form Product Information C D E F G Jesse Jewelers Product List 4 Style Code 5 M-MK 6 K-S 7 K-R 8 K-M 9 M-KF 10 K-T 11 M-TF Description Vintage Key Chains Plush Animal Key Chains Fun and Games Key Chains Pop Culture Key Chains Lanyard Key Chains Carabineer Key Chains Classic Key Chains Unit Price $ 7.50 $ 5.95 $ 9.25 $ 7.50 $ 3.75 $ 9.75 $ 6.50 31 Order Form Product Information +

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 General Management Questions!