I need help on part h.

Module 7 Developing an Excel Application | Excel EX 461 20. Reset cell 1. Test all of the macro butions, Check the Chair Sales worksheet to see how and where new 22. Save protection for the Order Form worksheet. the workbook as Chair workbook Orders with Macron, a macro-enabled workbook, and then close the Case Problem 4 There are no Data Files needed for this Case Problem. ui Resale Shoppe Debbie Oboyle opened a resale shop in Anacortes, Washington, in 2015. She sells everything form children's toys to clothes to jewelry to books. She wants to develop an electronic billingfinvoicing system for organizing sales by their type (for example, coat) and the intended user (for example, adulo. She asks you to follow her plan to create an Excel application that does these tasks. Complete the following Open a new, blank workbook, and then save it as Resale in the location specified by your instructor, 2. Rename the worksheet as Documentation, and then enter the company name, your name, the date, and a purpose statement. 3. Insert two additional worksheets, and then rename them as Invoice and Item Information. 4. In the Item Information worksheet, enter the data for the types of items and the age groups shown in Figure 7-47 Figure 7-47 Input data for the Resale Shoppe Baby Youth Shirta Dress 5. In the Invoice worksheet, create the invoice shown in Figure 7-48. Use defined names for the Customer Name, Street Address, City, Associate, Subtotal, Sales Tax, and Total to assist in creating formulas. Hint: Review the steps below before you begin to create the invoice. a. Enter the labels as shown in Figure 7-48. b. Change the column widths, and format the labels appropriately c. Use a function to insert the current date. d. Insert an input message in the Customer cells with a reminder about what data should be entered in cells C10, C11, and C12 e. For each of the four item lines (rows 17-20), use data validation rules to create lists of the different item groups and age groups that you entered in the ltem Information worksheet. Use appropriate input messages and error alerts. f. In each item's description,insert an input message with a reminder to enter a brie desciption of the item. g. In the Subtotal cell, enter a formula to add the price from each of the four items. h. In the Sales Tax cell, enter a formula that uses a defined name to calculate 8.5 percent of the subtotal i. In the Total cell, enter a formula that sums the Subtotal, and the Sales Tax cells. Trace precedents Show Formulas Define Nare 71 Use in Formula , Trace Dependents Enor Checking a Nan More gFunctionsManager B -9Evaluate Formula Formula Auditing AutoSum Recently Financial Logical Text Date &Lookup& Math & Remove Anows nsert Create from Selection Used - Time- Reference Trig Functions Manage Defined Names Function Library C7 Baby Toddler Youth Teen Adult 2 Toys 3 Coats 4 Shoes 5 Shirts 6 Pants 7 Dresses 8 Purses 9 Sheets 10 Towels 11 Blankets 12 Jewelry 13 Books 14 15 16 Documentation Invoice Item Iformation Ready a e @ xB Type here to search Be Irace Depend |Remove Arrow Remove Arro Trig. Functions . Manager gerCreate from Selection reate from selection thee keerence Function Library Defined Names Cutomer: Assoctiate: Item Group Age Group Description Price 2 4 SubTotal 0 Tax (85%) Total Documentation : Invoice item Information 0 Type here to search