How do you solve this with equations in excel? specifically, can you show the excel sheet with the corresponding formula to get the correct answer? thank you!

Required information Chapter 7: Applying Excel (Algo) The Chapter 7 Form worksheet is to be used to create your own worksheet version of the Review Problem in the text. Chapter 7: Applying Excel: Excel Worksheet (Algo) (Part 1 of 2) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell 826 enter the formula "= 817. After entering formulas in all of the cells that contained question marks, verify that the dollar amounts motch the numbers in Review Problem 1 . The LIFO inventory flow assumption is used throughout the probiem. Check your worksheet by changing the units sold in the Data to 6,000 for Year 2 . The cost of goods sold under absorption costing for Year 2 should now be $240,000. If it isn't, check cell C41. The formula in this cell should be =F(C26