Chapter 7: Applying Excel Step 1: Download the Applying Excel form located on the left-hand side, under files. If you have trouble, the file is also located in D2L 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. If it isn't, check cell C41. The formula in this cell should be =IF(C26