1. Now change all of the dollar amounts in the data area of your worksheet so that it looks like this: 1 2 A Chapter 1: Applying Excel B 3 Data 4 Sales $ 21,500 5 Variable costs: 6 Cost of goods sold 11,000 7 Variable selling $ 1,100 8 Variable administrative $ 900 9 Fixed costs: 10 Fixed selling $ 2,500 11 Fixed administrative $ 1,500 If your formulas are correct, you should get the correct answers to the following questions. (a) What is the gross margin now? Gross margin $ 6,000