Page 139 - Excel Workbook for Dummies

13_798452 ch08.qxp 3/13/06 7:47 PM Page 122
122 Part II: Using Formulas and Functions

1. Select the cell range B3:C6 and then open the Create Names dialog box (Insert➪
Names➪Create) and select only the Left Column check box in this dialog box
before you select OK.
2. Make the following entries in the designated cells:
• Office Furniture in the Type_of_Asset cell, C3
• 50000 in the Cost cell, C4
• 10 in the Life_in_years cell, C5
• 1000 in the Salvage cell, C6
3. Position the cell cursor in cell C9 and construct a formula that references the
Cost cell, C4, and then use the Fill handle to copy this formula across the row to
the cell range D9:F9.
4. Position the cell cursor in cell C10; there, type = (an equal sign) and then select
cell C9 before you type – (minus sign).
The formula in the cell and on the Formula bar now reads
=C9-
5. Click the Insert Function button on the Formula bar and then in the Insert Function
dialog box, select the SLN function in the Financial Category before you select OK.
6. Select the following cells to insert their names in the designated argument text
boxes and then select OK:
• Cost cell (C4) in the Cost text box
• Salvage cell (C6) in the Salvage text box
• Life_in_years cell (C5) in the Life text box

7. Copy the formula in cell C10 down to the cell range C11:C19.
8. Position the cell pointer in cell D10 and construct a formula that subtracts the
cost amount in D9 from the first-year depreciation returned by the SYD function
using the following arguments:
• Cost cell in the Cost text box
• Salvage cell in the Salvage text box
• Life_in_years cell in the Life text box
• Cell B10 in the Per text box

9. Copy the formula in cell D10 down the cell range D11:D19.
10. Position the cell pointer in cell E10 and construct a formula that subtracts the
cost amount in E9 from the first-year depreciation returned by the DB function
using the following arguments:

• Cost cell in the Cost text box
• Salvage cell in the Salvage text box
• Life_in_years cell in the Life text box
• Cell B10 in the Per text box
11. Copy the formula in cell E10 down the cell range E11:E19.
12. Position the cell pointer in cell F10 and construct a formula that subtracts the
cost amount in F9 from the first-year depreciation returned by the DDB function
using the following arguments:

• Cost cell in the Cost text box
• Salvage cell in the Salvage text box