Question 2I have a sales table that contains data on all of the cars for sale at the local dealership. Supposedly, this table contains data relating to the car’s manufacturer, country of origin, price, and amount sold for each brand. I use a pivot table to sort out the data in this table. What would happen if I drag the manufacturer field into the columns area of the pivot table?1 pointThe pivot table will display all manufacturers in a single column.The pivot table will create a column for every distinct car manufacturer present.The pivot table will put all the cars in a single column under the manufacturer and indent them.The pivot table will create a separate column for every car manufacturer entry.

Which is NOT true about pivot table?Question 1Select one:a.It allows a static view of your data.b.The data should be organised as stacked data.c.You can manipulate various ways to see data summary.d.You can change the summary functions.

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.

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 4Which of the following statements accurately describe pivot tables? Select all that apply.1 pointThe values in a pivot table are used to calculate and count data. A pivot table is a data summarization tool.The rows of a pivot table organize and group data horizontally. The calculated field in a pivot table is used to apply filters based on specific criteria.