The dataset you are working in is a PivotTable. What will happen if you select the first column, Sales Region, then you click Unpivot Other Columns?Select an answer:The column headings can be renamed however you prefer.The other columns will change from a PivotTable to rows of data.The other columns will change to rows, and the rows will change to columns.The other columns will change from rows of data to a PivotTabl

What does the Unpivot feature in a dataset allow you to do?Select an answer:Retrieve the underlying rows of data from a pivot tableTrim your data, such as getting rid of leading and trailing spaces.Rename a column without affecting the data source.Transpose the data so it displays longer vertically and not as wide.

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.

A pivot table is a data-summarization tool used in data processing. Which of the following tasks can pivot tables perform? Select all that apply.1 pointClean dataReorganize dataGroup dataCalculate totals from data

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

You have two Excel spreadsheets with data from separate reporting units. Both spreadsheets have the same column names. What Power Query Editor feature can you use to create a unified dataset?*UnifyAppendMergeGroup