Pass the Microsoft Microsoft Office Specialist 77-427 Questions and answers with CertsForce

Step 1:In the name box type B5:I299 (orClick cell B5, shift-clickcell I299).

Step 2:On the Home tab, select Conditional Formatting, and click New Rule

Step 3:In The Edit Formatting Rule dialog box select Use a formula to determine which cells to format, type the formula:=WEEKDAY($D5,2)>5, and click the Format button.

Step 4:In the Format Cells dialog box select bold, Underline Single, and click OK.

Step 5:In The Edit Formatting Rule dialog box click Ok.

Step 1:Click cell I7, Shift-click cell J7, right-click in this area, and from the context menu select Format Cells.

Step 2:In the Format Cells dialog box select Category Accounting, change Decimal places to: 5, and click OK.

Step 3:Click cell I8, shift-click cell J8,right-click in this area, and from the context menu select Format Cells.

Step 4:In the Format Cells dialog box select Category Accounting, change Decimal places to: 5, set Symbol to: ¥ Japanese, and click OK.

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.