Excel 2007 In Pictures

Practice: Manipulating Data

  1. Right-click this link (Mac users, press and hold down the mouse button):

    FlowerShop.xls
  2. When the menu appears, click Save Target As.
  3. Save FlowerShop.xls in the Practice Excel Files folder on your computer.
  4. Open FlowerShop.xls.
  5. In the Per-Bouquet Revenue worksheet, insert new blank rows above:

    Cost of Goods Sold
    Gross Revenue
    Commissions/Fees
    Net Revenue
  6. Change the name of Sheet 2 to Bouquet Sales.