nerdexam
Microsoft

77-727 · Question #1

77-727 Question #1: Real Exam Question with Answer & Explanation

To provide the solution: 1. On the "Customers" worksheet, click the Select All button OR press Ctrl+A. 2. Click the arrow next to Conditional Formatting from the Home tab in the Styles group, then select New Rule. 3. In the New Formatting Rule dialog box, select Use a formula to

Question

On the "Customers" worksheet, format the table so that every other row is shaded. Use a technique that automatically updates the formatting if you insert a new row.

Explanation

To provide the solution:

  1. On the "Customers" worksheet, click the Select All button OR press Ctrl+A.
  2. Click the arrow next to Conditional Formatting from the Home tab in the Styles group, then select New Rule.
  3. In the New Formatting Rule dialog box, select Use a formula to determine which cells to format.
  4. In the Format values where this formula is true. box, enter =MOD(ROW(),2)=0.
  5. Click the Format... button.
  6. Select the Fill tab from the Format Cells dialog box.
  7. Select the desired background and then click OK. You are able to view how the background would look in the Preview window in the New Formatting Rule dialog box.
  8. When satisfied, apply the formatting to the cells by clicking OK.

References: https://support.office.com/en-us/article/Apply-shading-to-alternate-rows-in-a-worksheet-A443B0F5-2D2F-42F6-9099-5DE09CD5EB80

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 77-727 Practice