Share Calibri B. Beste A A General $ % 9 ** 82% Number 5 Conditional Formatting Formats Table Cell Styles Styles Comments - - ao Analyze Data art Delete Format Undo Clipboard Fone Alignment Ce ng Analys M13 X A B D E G H 1 Click on the "SLN" tab and enter your name in Cell C1. If Cell C1 is left blank, you will not be able to see your score. 2 Each yellow cell requires a formula. 3 The formula must only contain cell addresses. 4 Each correct formula will begin with =, +, or 5 6 The basic mathematical operators are +, - and/ 7 Addition: To add the values in cells A1 and B4, the formula is A1+B4 8 Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is =A1-B4 9 Multiplication: To Cultiply the values in cells A1 and B4, the formula is-A1*84 10 Division: To divide the value in cell A1 by the value in cell B4, the formula is A1/B4 11 Instructions SIN Accessibility investigate TON E ity 11 AM H BW BX BY BZ CA Your score 4 A B D G Name Anthony James 2 0% On January 1 of the current year, the Anthony James Company purchased equipment for $43,000. The 3 equipment has an estimated useful life of 5 years and an estimated salvage value of $3,000 Complete the depreciation schedule below 5 Each formula in column D must include the SLN function 6 7 Cost $43,000 8 Salvage $3,000 9 Life (in years 5 10 11 12 January 1 Depreciation Accumulated December 31 13 Year book value Expense Depreciation book value 14 1 15 2 16 3 17 4 18 5 19 20 Instructions SLN +