Question

true or false
the horizontal cell rules option is used to find top 10 items
​

Answer 1

ANSWER:-

ITS TRUE

AM I WRITE

PLEASE GIVE ME BEST

Answer 2

Answer:

False

Explanation:

The fastest way to highlight top 3, 5, and 10 (or bottom n) values in Excel is to use an inbuilt conditional formatting rule.

Select the range in which you'd like to highlight numbers.

On the Home tab, in the Styles group, click Conditional Formatting.

In the drop-down menu, choose Top/Bottom Rules, and then click either Top 10 Items or Bottom 10 items.

In the dialog box, specify the number of items to highlight and choose one of the predefined formatting options. To apply formatting that is not in the list, click Custom Format. The changes made here are reflected in the dataset immediately. Click OK.