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

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

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.

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

Sophie is working on sales data from her company and wishes to see what the total profits were for each Region, on each month. What PivotTable would she draw? 0 / 1 pointThe PivotTable would have: Months as Values, Profits as Columns, and Profits as Rows.The PivotTable would have: Region as Values, Months as Columns, and Profits as Rows.The PivotTable would have: Profits as Values, Region as Columns, and Months as Rows.The PivotTable would have: Region as Values, Profits as Columns, and Months as Rows.

Pivot tables do not process dates like Excel usually does, because ordering dates can be necessary and grouping couldn't otherwise be done True False