Question: Change the summary function to Average for the data in the Values area and apply the Number number format with 2 decimal places to those
Change the summary function to Average for the data in the Values area and apply the Number number format with decimal places to those values.
In cell A use the text Average Scores to identify the values. In cell B use the text Months to identify the column headings. In cell A use the text Service Reps to identify the row headings. Apply Light Yellow, Pivot Style Medium to the PivotTable to match the other PivotTable.
Tiana wants to focus on scores for calls involving technical problems in February. Create a slicer for the Scores PivotTable based on the Call Type field. Resize the slicer to a height of Move the slicer so its upperleft corner is in cell F and its lowerright corner is in cell G Use the slicer to filter the Scores PivotTable by the Tech problem call type.
Create a timeline slicer based on the Date field in the Scores PivotTable. Resize the timeline slicer to a width of Move the slicer so that its upperleft corner appears within cell A and its lowerright corner appears in cell G Use the timeline slicer to show data for February only.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
