Finance Assignment | Professional Writing

1 point 5. Below is a spreadsheet showing product sales for the past 6 months. Assume we want to write a formula in cell C10 that we can copy later across 6 columns representing the past 6 months of sales. The formula needs to apply the unit cost of goods sold found in cell C2.

Enter the formula for cell C10 using spreadsheet syntax and the appropriate absolute and relative addresses to calculate total cost of goods sold for that period. C D E F Per unit cost of goods sold Jan Product a Product b Product c Total Feb 11 29 31 71 Mar 10 13 12 35 Apr 28 17 10 55 May 26 32 15 73 Jun 1 0 14 27 51 27 21 11 59 Total COGS Enter answer here

Get Finance homework help today