Exam PL-100 topic 4 question 11 discussion

DRAG DROP -
A call center manager monitors incoming phone calls. The manager analyzes the performance of phone reps by using a custom view. The view contains a custom field named Phone call Duration in Minutes.
The call center manager must present an Excel spreadsheet daily to upper management. The spreadsheet must contain the call center performance for further trending analysis and corrective actions.
You need to create the spreadsheet.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

Suggested Answer:
Step 1: Export the custom view to an Excel dynamic pivot table
You can export app data to an Office Excel PivotTable to see patterns and trends in data. An Excel PivotTable is a great way to summarize, analyze, explore, and present your app data.
Step 2: Create a pivot table, and then use the Phone Rep field as a category and the Phone call Duration in Minutes as field as series
Step 3: Set the formula for phone call duration in minutes to Average and add a pie chart linked to the pivot table
Step 4: Save the spreadsheet and upload it back to the system.
Reference:
https://docs.microsoft.com/en-us/powerapps/user/export-excel-pivottable