1 Project 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./
2- Second project : Project 8L Seasonings Inventory
Open the file e08L_Seasonings_Inventory, and then using your own name save it in your chapter folder as Lastname_Firstname_8L_Seasonings_Inventory From the source data, create a Moving Average chart to help identify the variation in seafood seasoning used over a four-week period using a 7-day interval. Begin the output range in cell A6. Move the chart to a new sheet. Format the chart attractively. Insert the file name in the left section of the footer on each page, center horizontally, set the orientation to Landscape, add appropriate information to the document properties, including the tag seasonings inventory and submit as directed by your instructor.
3rd project :Project 6L Tech Industry
From your student files, open the file e06L_Tech_Industry, and then save it in your chapter folder as Lastname_Firstname_6L_Tech_Industry Format the data attractively, add appropriate formulas, add sparklines, and insert a line chart in the sheet that tracks the data for the Irving location. Create a 3-D chart on a separate page based on the data in the worksheet, and format it attractively. Change the Fort Worth 2016 data point from 84 to 96. Insert the file name in the footer on each page, format each sheet for printing, add appropriate information to the document properties including the tags technology employers and submit as directed by your instructor
0 comments