In cells C$8-$F$13,$ insert a pivot table putting political party affiliation on the rows and values areas and registered to vote on the columns area. Go to the Voting Data worksheet. Select the PivotTable in the Tables group of the Insert tab of the Ribbon. Choose Select a table or range and select columns A$-$F in the Voting Data worksheet. Select Existing Worksheet and choose cell H$2$ in the Voting Data worksheet as the location for the pivot table. Do not check any additional boxes in the Create PivotTable dialog. In the PivotTable Fields list, drag$-$and$-$drop the Registered field into the columns area and Party field into the rows and values areas. In the Fields list, open the drop$-$down menu to the right of the Registered field and uncheck the $($blank$)$ box. Then open the drop$-$down menu for the Party field and uncheck the $($blank$)$ box. Select design Pivot Style Light $20$ in the PivotTable Styles group of the Design tab of the Ribbon. In the Home tab of the ribbon, set the pivot table text to Times New Roman, size $14$ pt$.$ font. Change the name of the pivot table to Table$1$ in the PivotTable group of the Analyze tab on the Ribbon. Select the pivot table. Then choose Move PivotTable in the Actions group of the Analyze tab on the Ribbon. In the Move PivotTable dialog, select cells C$8-$F$13$ in the Problem worksheet.

Note: Filters should be set to both the Registered and Party fields. Other options will not be graded.