Question

Difference between data bars and icon sets (answer in 20 - 25 words)​

Answer 1

Answer:

Use an icon set to present data in three to five categories that are distinguished by a threshold value. Each icon represents a range of values and each cell is annotated with the icon that represents that range. ... Point to Icon Sets, and then click the icon set that you want.

Explanation:

Data Bars are a popular type of conditional formatting that was introduced in Excel 2007. The basic idea of data bars is that Excel draws a bar in each cell whose length corresponds to the value of the cell relative to the other cells in the selected range. Data bars are a great way of seeing trends in your data.