Excel: Sounds Good Page 1 2 3 4 5 6 7 8 9 10 11 12 13

Create a Reference Cell

Try it: Open the spreadsheet we created in Eggs, Legs, and Pigs in a Basket.

 

Select row 2 and Insert three more Rows. This will give us room to work.

 

In cell A1 type the label, “Initial.”

 

In cell A2 type, “Increment.” Now, enter 100 in cell B1 and 5 in cell B2.

Calculate the sales: Cell D6 equals whatever we sold on the first day, plus the quantity we are forecasting for each day’s sales increase. That's your next task...

Home->Cells ->Insert