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

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 3What combination of settings was used to create this Pivot Table?

Information in pivot tables can only be used within the table. True False

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 of the following statements are true for Pivot Tables?(Multiple answers possible. Partial credit awarded)1 pointYou can use a text field in the Values areaYou can apply different functions - average, count, etc - to numeric fieldsNumeric values can only be summedCount can only be applied to text field