For a presentation, you want to sort customer orders for the quarter from largest to smallest, and also highlight orders that are larger than the average order amount. how will you do this?
O after sorting, use the below average conditional formatting rule to delete orders below average.
O after sorting, use the above average conditional formatting rule and select a highlighting color.
O after sorting, use the top 10% conditional formatting rule and select a highlighting color.