When setting up a spreadsheet to calculate depreciation in Excel you should type in the cost of asset multiple times since you need the cost to calculate depreciation for each year presented multiple times since you need the cost to calculate depreciation for each year presented and the cost changes each year only 1 time and use relative cell referencing in your depreciation formulas only 1 time and use absolute cell referencing in your depreciation formulas QUESTION 9 The purpose of depreciation is to record the decrease in value of an asset over time True False QUESTION 10 Double declining balance and sum of the the years digit deprecation methods use the same criteria as straight line depreciation True False