1. 1

    Imagine that you have a data set of customers for a business and you want to identify the top 30% of spenders (the 'star' customers). Which is the best method to indicate this visually?

  2. 2

    Suppose cells D10:D50 contain a range of numbers. How do you quickly color all values over $5,000?

  3. 3

    Suppose you want to identify the top 25% and bottom 25% of values in a column of data. Which method is the best?