Athey Department Store Athey Department Store in Fort Dodge, Iowa, has always accepted returns of any product purchased in its store. Mitchell Athey wants to develop a system for handling the returns. A routing slip will allow him to monitor who handled the return at each step. He will also be able to collect the returns data in a worksheet for count of returns in each category. Mitchell has started developing the routing slip, and he wants you to finish creating it. Complete the following: 1. Open the Athey workbook located in the ExcelB > Case4 folder included with your Data Files, and then save the workbook as Athey Routing Slip in the location specified by your instructor. 2. In the Documentation worksheet, enter your name and the date. 3. Create a defined name for the table on the Return Data worksheet to help you when you create formulas with VLOOKUP functions. (Hint: Use a name other than Returnibl because this name is already used as the defined name for the table on the Return Data worksheet.) 4. In the Return Routing worksheet, do the following: a. In cell 89, use a date function to display the current date. b. In cell 811, use an input message to inform the user to enter a product description in this cell. c. In cell 814, use a list validation for the Department located on the Return Data worksheet. d. In cell B16, use a list validation for the Resolution located on the Return Table worksheet (the range 13111). e. In cell 820, use an input message to inform the person entering the information to enter their name, initials, or Employee ID in this area.
The post Create a defined name for the table on Return Data worksheet appeared first on My Assignment Online.