Microsoft Excel 2013 Expert Part One 77-427 Exam Dumps: Updated Questions & Answers (October 2025)

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 I3.

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

Step 3:In the New Formatting Rule dialog box select Use a formula to determine which cells to format, in the Formal Values where this formula is true type:=TODAY()-I3>3, and then click the Format button.

Step 4:In the Format Cells dialog box click the Fill tab, click More Colors, in the Colors Dialog box click the Custom tab, change Green to 59, change Blue to 59, click OK, click OK, and finally click OK in the New Formatting Rule dialog box.

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: