Below is a spreadsheet showing product sales for the past 6 months. Assume we want to...

Transcribed Image Text:

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. A 1 23456789: B Per unit cost of goods sold C D E F G H 25 Jan Feb Mar Apr May Jun Product a 11 10 28 26 10 27 Product b 29 13 17 32 14 21 Product c 31 12 10 15 27 11 Total 71 35 55 73 51 59 10 Total COGS 11 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. A 1 23456789: B Per unit cost of goods sold C D E F G H 25 Jan Feb Mar Apr May Jun Product a 11 10 28 26 10 27 Product b 29 13 17 32 14 21 Product c 31 12 10 15 27 11 Total 71 35 55 73 51 59 10 Total COGS 11