Which of the following will you select as X in the series of clicks to highlight the top 10 items in a range of cells: (Select)Range of cells Home tab Styles group Conditional formatting X Top 10 items Change value and highlight option in dialog box if required OK? A) Icon Sets B) Color Scales C) Top/Bottom Rules D) Highlight Cells Rules

Question

Which of the following will you select as X in the series of clicks to highlight the top 10 items in a range of cells: (Select)Range of cells > Home tab > Styles group > Conditional formatting > X > Top 10 items > Change value and highlight option in dialog box if required > OK? A) Icon Sets B) Color Scales C) Top/Bottom Rules D) Highlight Cells Rules

Quizplus · Accepted Answer

The option to highlight top 10 items in a range of cells can be done using the Top/Bottom Rules in Conditional Formatting. Icon sets, color scales, and highlight cells rules are not suitable for highlighting a specific number of items in a range of cells.

Which of the Following Will You Select as X in the Series