B fx D Spreadsheet 6- Depreciation (full years) Complete the amounts in the cells with borders in columns E through 1. For # 1, 2, 4, 5, and 6, enter the answer in column E and copy/paste that entry to columns F through I For # 1, 2, 4, 5, and 6, use dollar signs for absolute references only where they are required. For #3, enter a separate formula in each column. Think about this one! The only number that may be typed into any cell is "2". Otherwise, use cell all references. Asset Method 1. Machine X Straight-line using formulas, no functions 2. Machine X Straight-line using the SLN function 3. Machine Y Double-declining balance using formulas, no functions 4. Machine Y 5. Machine Z Double-declining balance using the DDB function + Sum-of-years' digits using formulas, no functions 7 6. Machine Z Sum-of-years' digits using the SYD function 3 4 25 26 27 28 29 30 31 32 556 Ready Type here to search Ei 99- B fx Spreadsheet 6-Depreciation (full years) Complete the amounts in the cells with borders in columns E through I For # 1, 2, 4, 5, and 6, enter the answer in column E and copy/paste that entry to columns F through I For # 1, 2, 4, 5, and 6, use dollar signs for absolute references only where they are required. For #3, enter a separate formula in each column. Think about this one! The only number that may be typed into any cell is "2". Otherwise, use cell all references. Asset Method 1. Machine X Straight-line using formulas, no functions 2. Machine X Straight-line using the SLN function 3. Machine Y Double-declining balance using formulas, no functions 4. Machine Y 5. Machine Z Double-declining balance using the DDB function Sum-of-years' digits using formulas, no functions 7 2 6. Machine Z Sum-of-years' digits using the SYD function 3 4 25 26 27 28 29 30 31 32 556 Ready Type here to search Ei H 99