Calc 2.0 In Pictures

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

    Gross revenue per ream

    times

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

    Net revenue per ream

    times

    Total reams 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 Ream Revenue sheet.
  4. Fill the other cells in the worksheet to show the Gross and Net revenue for each month.