1.	Apply the Droplet theme. Apply the Title cell style to the cell B2. Apply the Yellow Orange theme colors.
2.	Unlock the ranges B15:K17 and D4:D12.
3.	Record a macro named Sort. Ensure the macro sorts the Inventory list in ascending order based on the dates listed in column F.
4.	Create a form control button beginning in the top-left corner of cell F4 and ending in the top-left corner of cell G7. Assign the Sort macro. Edit the button text to display the word Sort.
5.	Use the VBA Editor to create a new module. Type the following VBA code to create a custom depreciation function (be sure to include the blank lines after the first line and before the last line). Save and exit the VBA Editor. Function Depreciation (Value, Rate) Depreciation = Value * Rate End Function
6.	Insert two rows above row 12. Enter the Row heading DEPRECIATION RATE in cell B12, andDEPRECIATION in cell B13.
7.	Use the Depreciation function in cell D13 to calculate depreciation based on the Total Estimated Value on All Items (cell D14) and the Depreciation Rate (D12).
8.	Clear the contents in the range B17:K19.
9.	Create a new worksheet named Code to the right of the HOME CONTENTS INVENTORY LIST.
10.	Open the VBA Editor and display the module containing the sort code. Copy the code beginning with the text Sub Sort () and ending with the first instance of the text End Sub. Paste the contents in cell B2 of the Code worksheet. Do not close the VBA Editor.
11.	Open the VBA Editor and display the module containing the DEPRECIATION function. Copy the code beginning with the text Function Depreciation(Value, Rate) and ending with the first instance of the text End Function. Paste the contents in cell B23 of the Code worksheet. Close the VBA Editor.

Home Insert Page Layout Formulas Data Review View Share Insert Delete Format Franklin Goth 11 AA Wrap Text Paste B I U , A, |++ Merge & Center, $, % , * 0.00 conditional Format Cell Sort & Formatting as Table Styles A1 HOME CONTENTS INVENTORY LIST 4 NAME This shape represents a table sllcer. Table slicers are supported in Excel 2013 or later. slicers are supported in Excel 2013 or later This shape represents a table slicer. Table 5 ADDRESS 6 PHONE If the shape was modified in an earlier version of Excel, or it the workbook was saved in Excel 2007 or earlier, the slicer can't be used 7 INSURANCE POLICY NUMBER This shape represents a table slicer. Table slicers are supported in Excel 2013 or later. 8 INSURANCE AGENT NAME 9 INSURANCE AGENT PHONE 10 INSURANCE COMPANY 11 INSURANCE COMPANY PHONE 12 TOTAL ESTIMATED VALUE ON ALL ITEMS $575.00 13 If the shape was modified in an earlier version of Excel, or If the workbook was saved in Excel 2007 or earlier, the slicer 14 ROOM/ 15 Lving room 16 Hallwey 17 Kitchen 18 19 SN/ID NUMBER CURRENT VALUE PHOTO? NOTES 75.00 Yes S300.00 Yes Teak with bamboo inlay Cotfee table Gess sculpture Microwave oven Local seller $125.00 $300.00 $250.00 local artist 2/10/10 5/15/13 AB1234-58-789 S200.00 No 21 24 32 HOME CONTENTS INVENTORY LIST + Home Insert Page Layout Formulas Data Review View Share Insert Delete Format Franklin Goth 11 AA Wrap Text Paste B I U , A, |++ Merge & Center, $, % , * 0.00 conditional Format Cell Sort & Formatting as Table Styles A1 HOME CONTENTS INVENTORY LIST 4 NAME This shape represents a table sllcer. Table slicers are supported in Excel 2013 or later. slicers are supported in Excel 2013 or later This shape represents a table slicer. Table 5 ADDRESS 6 PHONE If the shape was modified in an earlier version of Excel, or it the workbook was saved in Excel 2007 or earlier, the slicer can't be used 7 INSURANCE POLICY NUMBER This shape represents a table slicer. Table slicers are supported in Excel 2013 or later. 8 INSURANCE AGENT NAME 9 INSURANCE AGENT PHONE 10 INSURANCE COMPANY 11 INSURANCE COMPANY PHONE 12 TOTAL ESTIMATED VALUE ON ALL ITEMS $575.00 13 If the shape was modified in an earlier version of Excel, or If the workbook was saved in Excel 2007 or earlier, the slicer 14 ROOM/ 15 Lving room 16 Hallwey 17 Kitchen 18 19 SN/ID NUMBER CURRENT VALUE PHOTO? NOTES 75.00 Yes S300.00 Yes Teak with bamboo inlay Cotfee table Gess sculpture Microwave oven Local seller $125.00 $300.00 $250.00 local artist 2/10/10 5/15/13 AB1234-58-789 S200.00 No 21 24 32 HOME CONTENTS INVENTORY LIST +