Question

Top/bottom rules allows user to apply conditional formatting cells that fall within the top or bottom numbers or percentile. how many items will it allow the user to include the rule?
A.) the top bottom 10 items or top 10% only

B.) the top 10 items and top 10% only

C.) the top or bottom 100 items only

D.) any logical number of items or percentages in top or bottom value frames

Answer 1

Answer:

The answer is (D) any logical number of items or percentages in top or bottom value frames

Explanation:

Excel’s Top/Bottom conditional formatting rule allows you to apply formatting to cells with numeric values that meet a certain statistical condition in relation to cells in the range. When you select this rule from the menu, it allows you to set how many items the formatting should apply. It is not limited to the ‘Top ten’ or ‘bottom ten’ only. The dialog box also gives you an option to change the ‘10’ to a different value that is within the constraints.