Requirement #3. Complete a depreciation schedule to enter fixed-asset data in an Excel table, calculate depreciation expense, and analyze the table data. (Chapter 6) Use this information, provided as of 1/31/2019, to create the depreciation schedule as of 1/31/2020 using appropriate headers and a table in which all pertinent information is displayed: Fixed Asset Automobile Store Fixtures Office Equipment Date of Acquisition Cost Salvage Value Useful Life Accumulated (years) Depreciation 1/31/2014 $32,000 $2,000 10 $15,000 1/31/2018 $11,300 $1,300 5 $2,000 1/31/2015 $6.900 $900 6 $4.000 CraftWorld uses the straight-line method of depreciation. In addition to the fixed assets shown, the company acquired new furniture on 1/31/2019. It cost $3,100, has an estimated four-year useful life, and an estimated salvage value of $300. Create the table so each of the six categories shown above is displayed in a separate column (note that some figures may appear different in your 1/31/2020 table than in the 1/31/2019 chart). Include columns for the annual depreciation expense and year-end book value. Use a function to calculate depreciation expense and use structured references when calculating the year-end book value. Sort the table by accumulated depreciation in ascending order and include a total row to sum each column (except Salvage Value; display the average for that column). Filter the table to display only assets for which the cost is greater than $5,000. Last, use Quick Analysis to apply data bars to the figures in the Salvage Value column. (Hint: Begin by highlighting the figures for which you will display the data bars.)