GO! Think: Project 7L Key Chains

Project Files

For Project 7L, you will need the following file:

e07L_Key_Chains

You will save your workbook as:

Lastname_Firstname_7L_Key_Chains

From your student files, open the file, e07L_Key_Chains and then save it in your chapter folder as Lastname_Firstname_7L_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.

Blizzard_Ally_e07L_Key_Chains Private Home Insert Draw Page Layout Formulas Data Review View Automate Tell me Calculation Options F43 fx \begin{tabular}{|c|c|c|c|c|} \hline & A & B & & c \\ \hline 1 & \multicolumn{4}{|c|}{ Jesse Jewelers } \\ \hline 2 & \multicolumn{4}{|c|}{ Product List } \\ \hline \multicolumn{5}{|l|}{3} \\ \hline 4 & Style Code & Description & \multicolumn{2}{|c|}{ Unit Price } \\ \hline 5 & M-MK & Vintage Key Chains & $ & 7.50 \\ \hline 6 & K-S & Plush Animal Key Chains & $ & 5.95 \\ \hline 7 & K-R & Fun and Games Key Chains & $ & 9.25 \\ \hline 8 & K-M & Pop Culture Key Chains & $ & 7.50 \\ \hline 9 & MKF & Lanyard Key Chains & $ & 3.75 \\ \hline 10 & KT & Carabineer Key Chains & $ & 9.75 \\ \hline 11 & M-TF & Classic Key Chains & $ & 6.50 \\ \hline \end{tabular} Blizzard_Ally_e07L_Key_Chains Private Home Insert Draw Page Layout Formulas Data Review View Automate Tell me A1 fx Jesse Jewelers 1 2 3 4 Customer Name Peterson Travel Accessories, Inc. 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 53 54 55 56 57 58 59 60 61 02 63 Total