Question 1A pivot table will remove duplicates from a field when presenting the values in a pivot table view.1 pointTrueFalse

The order of the fields in the area of a pivot table does not matter and it is based on the order of the fields in the original table.1 pointTrueFalse

Question 1According to the video checklist, what should you remove before making a Pivot Table?1 pointValue fields Date fields Blank rows, columns, and cells Row labels

Pivot tables must show the pivot table on the same sheet as the data, otherwise Excel cannot do pivot charts automatically 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.

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