On January 1 of the current year, the J Company purchased office machinery for $91,000. The office machinery has an estimated useful life of 5 years and an estimated salvage value of $6,000. Complete the depreciation schedule below. Each formula in column D must include the SLN function. Eachyclow cell requires a formula The formula must only conali celi addresues Each correct formula wi begin with =,+, or The basc mathematical operatoes are,+ 7 and / Addition: To add the values in ceili A1 and 64 , the formila 6=Al+B4 Subtraction: To wobtract the value in cel B4 from the value in celi Al, the formala is a Ad-104 Multiplication: To multiply the values in cells A1 and B4, the formula is =At*B4 Using the stu function The StN function has the folowing wntax aW(coDT, SALADL,ARE) Each variable may be exher a value or a formula that returns a value. Whing abiolute addeesses 17. Once a formula is ereated, you wil often waet to copy the formala to other columns and rowh. It't important to underctand that excel alwayi uies "relat ive addresev" unless you ind sate ofherwise by creating an "absolule address, for esample, if you are calculatinc the cost of purchasing 2 bokes of cereal at a in celf 028 at "Multiply the value in the cell in the same column (column B) 2 rows abore (row 26 ) by the yalue in the celi in the same colurnn 1 row aboye (row 27 This worki lut fine to calculate the coot of 2 boxes, but, t we copy the formula in ced 628 to Cl. ExC2, Since Cell C2? is blenk, the formula wil return a value of 50 (which is an emcellem deal for 6 boxes of cereal, bet it isn' accuratel) 2I. Ads ne a 5 sign before the column or row reference locks the formula ta a ipectic location. If we modfy the formula in cell e?s to e876*s8527 before we copy the farmula, tacel wil not change the forw or the column of the second vatiable when