5 Record a macro named Sort, be sure to use relative references. Ensure the macro sorts the data in the table in ascending order based on SKU (column A). Stop the Macro Recorder and Save the workbook as a Macro-Enabled Template.

B5 Douglas_EXP19. Exp19_Excel_Ch 12_Cap_Bulldog_Collectibles_In... Douglas, Breanna (bdoug2) C File Home Insert Draw Page Layout Formulas Data Review View Power File Home Insert Draw Design Layout References Mailings Review View Tell me Franklin Gothic M - 11 -AA A Wrap Text * Cut E e Copy Format Painter Enable Edit 0 PROTECTED VIEW Steps to Perform: Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Paste BIU- Merge & Center Clipboard Font Alignment Step Instructions Points Possible E2 f 1 0 Start Excel. Download and open the file named EXP19_Excel_Ch12_Cap_Inventory.xlsx. Grader has automatically added your last name to the beginning of the filename. A B D 2 Delete the Inventory Pick List and Bin Lookup worksheets. 4 3 0 Delete the INVENTORY PICK LIST and BIN LOOKUP icons located respectively in cells E2 and F2. Then Clear all existing Data Validation in the range A1:K15. 1 INVENTORY LIST 4 Delete the values in the range B5:J15. 4 2 TOTAL INVENTORY VALUE: INVENTORY ITEMS: BIN COUNT: 5 0 Record a macro named Sort, be sure to use relative references. Ensure the macro sorts the data in the table in ascending order based on SKU (column A). Stop the Macro Recorder and Save the workbook as a Macro-Enabled Template. 3 4 SKU DESCRIPTION 1 BIN # 6 2 Create a form control button that spans the cell E2:E3. Assign the Sort macro and edit the button text to Sort. 5 7 Use the VBA Editor to create a new module. 0 6 Type the following VBA code to create a custom Inventory Value function then save and exit the VBA Editor (be sure to leave a blank line between each line and before End Function): 7 Function InventoryValue (QTY, COST) 8 InventoryValue = QTY * COST 9 10 8 9 9 Click cell J5 and use the newly created Inventory Value function to calculate the value of the inventory for each item in column I. 11 9 0 Use the VBA Editor to create a new module named ProtectWorkbook. Type the following VBA statements to create the sub procedure (leave appropriate line spacing). Inventory List # Ready Page 1 of 3 40 of 687 words Type here to search o E x) 11:11 AM 12/7/2020