Microsoft 77-427 Dumps

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:

Step 1:Click cell E2, and click the Insert Function button.

Step 2:In the Insert Function dialog box select Category Lookup & Reference, select function LOOKUP, and click the OK button.

Step 3:In the Select Arguments dialog box make sure lookup, value, lookup vector, result vector is select and click OK.

Step 4:For Lookup_value click cell D2, for Lookup_vector select cellsI12:K12, for Result vector cells I11:K11, and click the OK button.

Step 5:Click cell E2,click in cell reference I12 in the formula field, and press the F4 key (to make I12 an absolute reference.

.

Step 6: Make K12, I11 and K11 absolute references using F4 in the same way.

Result will be:

Step 7: Click cell E2, and copy downwards to E44.

Result will be like:

Step 1:Drag the Date field to the Filters area.

Step 2:Click on Date in the Pivot table, select 8-Apr-13, and click OK.

Step 3:Click on Date in the Pivot table, select 9-Apr-13, and click OK.

Step 4:Click on Date in the Pivot table, select 10-Apr-13, and click OK.

Step 5:Click on Date in the Pivot table, select 11-Apr-13, and click OK.

Step 5: Click on Date in the Pivot table, select 12-Apr-13, and click OK.