77-427 Microsoft Excel 2013 Expert Part One Free Practice Exam Questions (2025 Updated)

Step 1:In the name box type B4:I299 (or Click cell B4, shift-click cell I299).

Step 2:Click the INSERT tab, click the PivotChart button, and select PivotChart.

Step 3:In the Create PivotChart dialog box make sure New Worksheet is select, and click OK.

Step 4: Rename the worksheet by right-clicking on the sheet name (bottom left corner), select Rename from the context menu, and type: Billing_Pivot

Step5:Select the fields Office and Name.

Step 6: Click-and-drag the Charge field tothe Values area.

Step 7: Click-and-drag the Duration field to the Values area, then click on the new Sum of Duration box, and select Value Field Settings.

Step 8: In the Value Field Settings box, select Average, click OK.

Step 9:Again click-and-drag the Duration field to the Values area, then click on the new Sum of Duration box, and select Value Field Settings.

Step 10: In the Value Field Settings box, selectCount, click OK.

The result will look like: