On the Winter Program Revenue sheet, in cell B4, create a DAVERAGE function to calculate the average of the Amount field for the Lessons category. The Criteria range has been set up for you in the range A3:A4. In cell C4, create a DSUM to calculate the total of the Amount field for the Lessons category. Format the range B4:C4 using Accounting Number Format. In the Winter Program Revenue sheet, click cell A9, and then insert the Recommended PivotTable Sum of Amount by Category in a new worksheet. Rename the worksheet Revenue PivotTable. Use the Month field as the report filter. Use the Ski Area field as the row labels and the Category field as the column labels. Format the values in the PivotTable using the Number category with zero decimal places and the 1000 separator. Mt On 10:25 2012- np 0010 XL COMP GRADER CAP Water Reve