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

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: On the Home tab select Conditional Formatting, and click Manage Rules.

Step 2: In the Conditional Formatting Rules Manager, select Show formatting rules for: This worksheet,click on the fourth rule Red Text with Strikethrough, and click Edit Rule.

Step 3:Change the formula to=$E5<"7:00:00"and click OK

Step 1:Clickthe chart, and click on the Duration data series in the diagram.

Step 2:Click on the Charts Elements button (upper right corner of Chart), check the Trendline Box, click Trendline arrow and make sure Linear is selected.