Excel: Legs, Eggs and Pigs Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

Change the Variables Rename the Spreadsheet Double click on the tab for Eggs (2). Rename this spreadsheet to: Legs.   Update the product data Go to Cell B2 and change Eggs to Legs. AutoFill Cell B2 to the bottom of Column B.   Change the Net The net for chicken legs is 3.25. Enter that amount and AutoFill.   Change the Quantity For quantity we will start at 50 and add 5 per day. Type 50 in cell D2. Type 55 in D3 Select D2 and D3 and AutoFill. The work on the Pig’s page is similar. Rename the spreadsheet to Pigs in a Basket. Change the product to Pigs. The Net is 4.75. and the quantity starts at 200 but only adds one more per day.