nerdexam
Microsoft

77-727 · Question #5

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

Explanation/Reference: 1. Select the cells in the "OrderTotal" column which is the data range you are required to highlight the cells which are above-average. 2. Go to Home tab-Conditional Formatting-Top/Bottom Rules-Highlight Cells that are Above Average-Above Average option. 3.

Question

On the "Orders-worksheet", use an automatic formatting method to format cells in the "OrderTotal" column that contain above-average values by applying Green Fill with Dark Green Text. Use a technique that automatically updates the formatting if the column values change.

Explanation

Explanation/Reference:

  1. Select the cells in the "OrderTotal" column which is the data range you are required to highlight the cells which are above-average.
  2. Go to Home tab-Conditional Formatting-Top/Bottom Rules-Highlight Cells that are Above Average-Above Average option.
  3. A popped up dialog box will then appear, select the Green Fill with Dark Green Text option as desired.
  4. Click OK. Reference: https://support.office.com/en-us/article/excel-highlight-above-average-html

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 77-727 Practice