Practice: Manipulating Data
-
Right-click this link (Mac users, press the CTRL key while pressing the mouse button.):
FlowerShop.xls
-
When the menu appears, click Save Target As.
-
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.