Question $1($first pic$)$:

$1)$ Create a PivotTable using the raw data to the left. Place the PivotTable into the "Pivot $1"$ worksheet.

$2)$ Find the SUM of sales per each Category. Place the Category field in the Row field area.

$3)$ Create a Column PivotChart to display the sum of sales per each category.

$4)$ Insert a Category Slicer so that you can easily filter fields for the PivotTable & PivotChart.

Question $2($second pic$)$:

$1)$ Create a PivotTable using the raw data to the left. Place the PivotTable into the "Pivot $2"$ worksheet.

$2)$ Find the SUM of the Average Sale Price for each Neighborhood. The list of neighborhoods should be in the row field area.

$3)$ Place the "Type of Home" in the Filter field area and filter the PivotTable to only display $"01$ One Family Homes".

$4)$ Create a Pie PivotChart to display the Total Average Sale Price for each neighborhood.

$5)$ Set up a Neighborhood slicer and make sure the following neighborhoods are the only ones selected: Chelsea, East Village, Lower East Side, Midtown East, and Soho.

Question $3($third pic$)$:

$1)$ Create a PivotTable using the raw data to the left. Place the PivotTable into the "Pivot $3"$ worksheet.

$2)$ Broken up by the Post Type, show the total number of interactions for paid and unpaid posts. Make sure the post type and whether the post was paid are both in the Row field area.

Note: You will need to create a calculated field adding the comment, like and share columns together. Make sure the new calculated field is labeled "Total Interactions".

$3)$ Placing the "Post Month" in the Filter field area, filter the month to only display "December" data in the PivotTable.

$4)$ Create a Column PivotChart to display the Total Interactions per each post type for both unpaid and paid posts.

$5)$ Set up a "Type" slicer and select the following types: Link and Photo.