Excel 2007 In Pictures

  1. In the Bouquet Sales sheet, insert a new column for April between the March and May columns.
  2. Copy the Bouquets shipped and Bouquets sold in store sales figures for March and paste them in for April.
  3. Using the Fill Handle, drag the formula from Total Bouquets Sold in March (cell D6) so the formula applies to April.
  4. The formula in cell E6 should total April's sales.

    When you're done, the sheets should look like this:

  5. Save the FlowerShop workbook, then close it.