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

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: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 I5, click the Insert Function button, select category Lookup & Reference, select VLOOKUP, and click OK.

Step 2:In the Functions arguments dialog box, for Lookup Value click cell C5, for Table_Array switch to Hourly_rates worksheetclick Cell B2, shift-click cell C29.

Step 3:For Col_index_num type 2, for Range_lookup select FALSE, and click OK.

Step 4:Edit the Formula by typing *5 in the formula box, and change the B2 and C29 references to absolute references by clicking them and using the F4 key.

Step 5:Copy the formula in cell I5 downward to cell I299.

Will look like: