Excel 2007 In Pictures

  1. In cell B4 in the Income sheet, create a formula that multiplies

    Gross revenue per bouquet

    times

    Total bouquets sold in January
  2. In cell B5, create a formula that multiplies

    Net revenue per bouquet

    times

    Total bouquets sold in January
  3. Edit the formulas in both cells to employ absolute references to the Gross revenue and Net revenue figures in the Per-Bouquet Revenue sheet.
  4. Fill the other cells in the worksheet to show the Gross and Net revenue for each month.