When is it appropriate to use an absolute reference?

C.

Explanation:

i just had this question on a paper test and i got it right i hope this helps

Answer is A

Explanation:

Absolute references

There may be times when you do not want a cell reference to change when filling cells. Unlike relative references, absolute references do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant.

The total amount of the company's merchandise purchases for the month will be equal to:

$84,100

Explanation:

a) Data and Calculations:

Cost of goods sold = $70,600

Beginning Inventory = $16,500

Ending Inventory = $30,000

Purchases = x

Cost of goods sold = Beginning inventory + Purchases - Ending Inventory

$70,600 = $16,500 + Purchases - $30,000

Therefore $70,600 + $30,000 = Cost of goods available for sale

and Beginning inventory ($16,500) + Purchases = Cost of goods available for sale.

Purchases = $100,600 - $16,500

Purchases = $84,100