Which four actions should you perform in sequence?

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.

View Answer

Answer:

Explanation:

Timeline

Description automatically generated with low confidence

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.