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.

Create a PivotTable that shows total sales and number of unitssold for each sales representative per product

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 3Modify the Pivot Table to show Year Sold in the columns.

Arrange the following steps in correct order to create a Pivot Table in Excel?Answer areaChoose the type of calculation you want to perform on the data (e.g., sum, count, average).Review and analyze the summarized data presented in the PivotTable.Drag and drop the fields from the PivotTable Field List to the Rows, Columns, Values, or Filters areas.Select the data range that you want to analyze.Click on the "Insert" tab in the Excel ribbon.Click on the "PivotTable" button and select "PivotTable" from the dropdown menu.Adjust the layout and formatting of the PivotTable as needed.SubmitReset AnswerPreviousNext

Which DAX formula should be used in Power Pivot to create a measure that calculates the average discount percentage for each region in a dataset containing columns such as Date, Region, Sales, and Discount for 3 months, while excluding sales with a discount percentage of zero?