Question

To highlight cells that are the 5 highest numbers in a range, what option under conditional formatting will you pick?

1) Top/Bottom Rules
2) Data Bars
3) Color Scales
4) Icon Sets

Answer 1

Choose the 'Top/Bottom Rules' option under conditional formatting in Excel to highlight the 5 highest numbers in a range. Option 1 is correct.

Step-by-step explanation:

To highlight cells that are the 5 highest numbers in a range in Excel, you should choose the Top/Bottom Rules option under conditional formatting.

This feature allows you to apply a specific format to the top N cells in a range, where N can be any number you choose. In this case, since you want to highlight the 5 highest numbers, you would choose to format only the top 5 cells.

Hence, to highlight the 5 highest numbers in a range using conditional formatting, you would pick the option of 'Top/Bottom Rules.' This option allows you to highlight cells based on their values.

You can choose to highlight the top 5 numbers in the range by selecting 'Top 10%' and then specifying the number as 5. This will highlight the 5 highest numbers in the range.

Therefore, option 1 is correct.