Question 3What combination of settings was used to create this Pivot Table?

Question 1When you create a Pivot Table, your data must be in a Table beforehand.

For the next two questions, consider the following pivot table, made for a mobile game to manage player statistics:How would I create the pivot table in this layout?1 pointMonsters then Rooms as Columns; Players as Rows; Kills as Values.Rooms then Monsters as Columns; Players then Kills as Rows.Rooms as Columns; Monsters as Rows; Kills as Values.Rooms as Columns; Monsters as Rows; Players as Values.

Question 5You have created a pivot table from from this Table A:FruitsCategoryAmountBlueberryBerry230CranberryBerry340BlackberryBerry120Green GrapesGrapes400Seedless GrapesGrapes250………You now want to display the number of fruits for each category. How should you configure your pivot table?1 pointDrag Category into Rows, then drag Amount into Values.Drag Amount into Rows, then drag Fruit into Values.Drag Fruit into Rows, then drag Category into Columns.Drag Category into Rows, then drag Amount into Columns.

Which of the following can be created from a PivotTable? 1. PivotFilters 2. PivotCharts 3. PivotFormats 4. PivotFills

Question 3Modify the Pivot Table to show Year Sold in the columns.