Required information Chapter 6: 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 B13 enter the formula "=B5". Step 3: Check your worksheet by changing the fixed expenses to $270,000. If your worksheet is operating properly, the degree of operating leverage should be 10. If you do not get this answer, find the errors in your worksheet and correct them. Step 4: Proceed to the requirements below only after completing your worksheet as it will be used to answer the following questions. 4. Confirm your calculations in Requirement 3 above by increasing the unit sales in your worksheet by 20% so that the Data area looks like this: B 1 Chapter 6: Applying Excel 2 3 Data 4 5 Unit sales Selling price per unit Variable expenses per unit Fixed expenses 24,000 units $ 40 per unit $ 28 per unit $ 216,000 6 7 (a) What is net operating income? (Negative amount should be indicated by a minus sign.) Net operating income (loss) (b) By what percentage did the net operating income increase? Percentage increase in net operating income