5 points Boos Required Information Chapter 7: Applying Excel Step t Download the Applying Excel form located on the left hand side, under files. If you have trouble, the file is also located in D21 under Course Administration Step 2 Then enter formulas in all cells that contain question marks. For example, in cell B26 enter the formula - B17. Step 3. 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. It isn't check cell C4: The formula in this cell should be =IFC26