77-427 – Microsoft Excel 2013 Expert Part 1

Reference / correct answer:

References: https://support.office.com/en-us/article/what-and-where-is-backstage-view-04610088406c-43d0-98a0-c1999ab4ef53

Reference / correct answer:

Step 1: Right-Click in cell I3, and select Insert comment from the context menu.

Step 2: Type: If red fill is present, update exchange rates

Step 3: Click cell I3.

You can test by hover above cell I3:

Reference / correct answer:

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 Bold and Underline Rule, and move it to the top with the upward arrow.

Step 3: Move the Red Text rule to the second place, Pink fill to the third. Will look like:

Step 4: Click OK.