please help with the weighted average

thank you!

Fevise your worksatet to renect here upuated assumpuons aric then diswer the quesuons that ronow. Required: 1. Use your spreadsheet to recalculate the Cost of Goods Sold, Inventory balances, and Gross Profit under each method ind enter your results below, (Round your answers to the nearest whole dollar amount.) 2. Which statement is truc reparding the purpose of usinn absolute cell referencing in your spreadsheet