How can data analysts use the Conditional Formatting tool in Excel to aid in data analysis of bike sales records?
- to highlight values in the revenue column that are above average
- to list sales order numbers from lowest to highest
- to separate the contents of the product description column into separate columns
- to show only sales from the United States
| Explanation & Hint:
By using conditional formatting, a data analyst can highlight cells that contain certain values or that meet certain criteria. |