Excel 2010 In Pictures

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 In cell A7, type:

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

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

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