4. Insert two new Rows above Row 1. Add the following labels:
A1=Start
A2=Increment

B1=10
B2=2

5. Create a formula in Cell D4: =B1.

6. Create a formula in Cell D5 that adds the first day's quantity to the increment in Cell B2. Select Cell D5 and create an Absolute cell reference. Autofill the formula to all of the rows that have dates.

7. Rename the spreadsheet to "Budgie." Make a copy of the Budgie spreadsheet and name it Expert.

Change the Product in cell B4 to Expert. Autofill it down to B6 (Change all of the Budgies to Expert)
Change the Price in cell C4 to \$450.00. Autofill it down to C6
Change the Start in B1=5
Change in Increment in B2=3

Keep going...

Before You Begin: Open a new, blank Spreadsheet in Excel 2010.

1.Create a new spreadsheet for Computers Are Us.

A1=Date
B1=Product
C1=Price
D1=Quantity
E1=Total

A2=January 5, 2006;
A3=January 6, 2006
B2=Budgie,
B3=Budgie,
C2=\$350,
C3=\$350
D2=10,
D3=5
Format Column C for currency

2. Select E2 and calculate the Total of the Price times the Quantity.

3. Select Row 2, copy it, and paste it to Rows 3 through 13. 