in column A$.$

In column $E$ of the data table, note the target dollar value in cell E$16.$ In column E of the data table, create an IF formula that will display TARGET if the revenue in than or equal to the target value in E$16,$ or MISS otherwise.

Revenue Pivot Table Pivot Table task pane is set to Sum of Revenue.

What is the lowest sum of revenue in the pivot table? $($Note: Conditional formatting can helpl$)$

$\backslash$table$[[$Lowest revenue,Month,,$],[131,$December $0,$Sunday,$0]]$

What is the highest sum of revenue in the pivot table? $($Note: Conditional formatting can helpl$)$

Highest revenue

Month

Day

November $$

Target Pivot Table rows. Next to get the counts of TARGET and MISS, use hit target a second time in the values field of the pivot table.

Which month hit the target revenue most frequently?

Month: