4. Insert two new Rows above
Row 1. Add the following labels:
A1=Start
A2=Increment
Add the following data:
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.
Please do the following steps:
1.Create a
new spreadsheet for Computers Are Us.
Add the
following labels:
A1=Date
B1=Product
C1=Price
D1=Quantity
E1=Total
Add the following data:
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.
