| Download the Applying Excel form and enter formulas in all cells that contain question marks. |
|
For example, in cell B26 enter the formula “= B17”. |
| After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the numbers in Review Problem 1. |
| 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%u2019t, check cell C41. The formula in this cell should be =IF(C26 |
| Save your completed Applying Excel form to your computer and then upload it here by clicking %u201CBrowse.%u201D Next, click %u201CSave.%u201D You will use this worksheet to answer the questions in Part 2. |