9
QuizMultiple Choice

Pivot Tables and Pivot Charts — Unit test

Question 9 • Computer Applications - Office 2016 - EL3520 A

Top/Bottom Rules allow a user to apply conditional formatting to cells that fall within the top or bottom numbers or percentile. How many items will it allow the user to include in the rule?

Answer
A
the top or bottom 10 items or top or bottom 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
Previous
Next