Tools Data Window Help Excel File Edit AutoSave Home Insert Draw View Insert 5 Page Layout Format 5 : HW Unit 18a Formulas Data Review View Developer 11 A = Wrap Text General IS A A Merge & Center $ % 92 Conditional Formatting Calibri (Body) BIU x fx A 1 Unit 18 1 3 Problem B FIGHT Deere & Company manufactures, distributes, and finances a full range of agricultural equipment, a broad range of industrial equipment for construction, forestry, and public works; and a variety of lawn and grounds care equipment. The company also provides credit, health care and insurance products for businesses and the general 4 public. Consider the following information from the Deere & Company 2000 Annual Report: 1998 1 3,822 6 (in millions) 7 Sales 8 Cost of goods sold 9 Gross margin 1997 12,791 8,481 4 310 1999 2000 11,75113,137 3.178 3.573 11 1. Prepare a statement showing the trend percentages for each item using 1997 as the base year. 12 2. Comment on the trends noted in part (1) Set up a chart similar to the one above, but compute each year compared to the base year answer cell to see what I did for 1997 1998 1999 2000 15 Sales 100% 10% 16 Cost of Goods Sold 100% R 1 17 Gross Margin 1 00%