Save FlowerShop.xls in the Practice Excel Files folder on your computer.
Open FlowerShop.xls.
In the Per-Bouquet Revenue worksheet, insert new blank rows above:Cost of Goods Sold
Gross Revenue
Commissions/Fees
Net Revenue
Change the name of Sheet 2 to Bouquet Sales.
In the Bouquet Sales sheet, insert a new column for April between the March and Maycolumns.
Copy the Bouquets shipped and Bouquets sold in store sales figures for March and paste them in for April.
Using the Fill Handle, drag the formula from Total Bouquets Sold in March (cell D6) so the formula applies to April.
The formula in cell E6 should total April's sales.When you're done, the sheets should look like this:
