Revise your worksheet to reflect these updated assumptions and then answer the questions that follow. Requlred: 1. Use your spreadsheet to recalculate the Cost of Goods Sold, Inventory balances, and Gross Profit under each method and ent your results below: (Round your answers to the nearest whole doller amount.) 2. Which statement is true regarding the purpose of using absolute cell referencing in your spreadsheet? An absolute cell reference contains a dollar sign (\$) in the row or column coordinate (or both) to indicate the result is a currency value. You can use an absolute reference to keep a row and/or column constant