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.