Question

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.

Answer 1

Answer:

=$C$2*C8

Explanation:

See attached

Answer 2

The formula for cell C10 is (=$C$2*C8)

Explanation:

please refer to the attached screenshot for better understanding.

• In spreadsheet softwares like excel, all cell references are relative references by default. When we copy them across cells, they update based on the relative position of rows and columns.
• For example, if we copy the formula =SUM(C5:C7) from C8 to H8 , the formula will become =SUM(H5:H7).
• Relative references are used when we need to repeat the same calculation across multiple rows or columns.
• Unlike relative references, absolute references do not change when copied or filled. We can use an absolute reference to keep a row and/or column same.

Syntax:

• An absolute reference is used in a formula by the adding a dollar sign ($) before the column and row.  
• Here our formula is =$C$2*C8
• “$C$2” part of the formula denotes absolute reference. It will remain constant across the row when copied from one cell to another.

• “C8” part of the formula denotes relative reference and it will change across the row while copied. It will help us to calculate the Total COGS for different months when multiplied with the unit price, which is constant.

Hence, The formula for cell C10 is (=$C$2*C8)

#SPJ2