AutoSave O OFF A 6 5 - Lab-1-Exercise-3 Q Q v Home Insert Draw Page Layout Formulas Data Review View Share Comments Calibri (Body) 12 A" A" E 2 Wrap Text v General Ex AY- O. Paste BI U V V LA~ Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Ideas Formatting as Table Styles X v Filter Select A4 A B C D E F G H L M N 0 P Q R LOOKUP FORM Information Table Stationery Items | Product Code Price Enter Stationery Item Here: Product Code Is: Product Package Price Is: Pencils A12 10 Pens A44 20 Erasers G14 10 Laser Paper P12 15 Highlighters C12 18 Markers C55 15 Inkjet Paper P33 10 Hints: Tasks: You should try to solve the problems without these hints ound color to reveal some hints. 16 1. Use the Data Validation control to insert a drop-down menu in cell A4 such that the drop- 17 down menu allows a choice of stationery items shown in the information table. 18 19 2. Use the VLOOKUP function to retrieve the product code and package price in cells B4 and C4. 20 Sheet1 + - + 100%