Google Sheets In Pictures

6 In cell B5, create a formula that multiplies

Net revenue per bouquet


Total bouquets sold in January

7 Edit the formulas in both cells to employ absolute references... the Gross revenue and Net revenue figures in the Per-Bouquet Revenue sheet.

8 Fill the other cells in the worksheet to show the Gross and Net revenue for each month.

The worksheet should look like this:

9 Close the FlowerShop spreadsheet.