Practice: Advanced Calculations

Open the FlowerShop workbook from the Practice Excel Files folder.

Rename the Sheet 3 tab Income.

On the Income sheet, type:

Income

in cell A1.

Make it Arial, 12 point, bold.

Set up the worksheet so Gross Revenue and Net Revenue can be recorded for the months January through May.

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

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

Gross revenue per bouquet

times

Total bouquets sold in January

In cell B5, create a formula that multiplies

Net revenue per bouquet

times

Total bouquets sold in January

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

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

In cell A7, type:

How much money was made in months with sales higher than $5000?

Click cell G7, then use the Function Wizard to get the answer.

TIP: Use the SUMIF function in the Math & Trig category.

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

Save and close the FlowerShop workbook.