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