Total

$16\mathrm{.}9$ Excel Problem$*$

Required

Download the spreadsheet for problem $16\mathrm{.}9$ from the website for this

extbook. Write formulas to calculate the total depreciation expense and

to display the correct values in the following three columns: Age,

Depreciation Rate, and Depreciation Expense. $($Hint: You will need to use

the VLOOKUP and MATCH functions to do this. You may also want to

read the article "Double$-$Teaming in Excel," by Judith K$.$ Welch, Lois S$.$

Mahoney, and Daniel R$.$ Brickner, in the November $2005$ issue of the

Journal of Accountancy, from which this problem was adapted.$)$