Change the Variables

Next Step: Change a few variables, please.

 

Rename the Spreadsheet

Double click on the tab for Eggs (2).

Rename this spreadsheet: 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

The quantity starts at 50 and adds 5 per day.

In Cell D2 type: 50.

In Cell D3 type: 55.

Select D2 and D3 and AutoFill.

The work on the Pig’s page is similar. Copy the Eggs sheet. Rename the new Eggs(2) sheet to Pigs. Change the product to Pigs. The Net is 4.75 and the quantity starts at 200 but only adds one more per day.