Quiz

  1. 1
    Intermediate

    Your boss has given you a list of data and asked you to identify who your star customers are (your top 30%). How would you highlight only your top customers?

  2. 2
    Intermediate

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

  3. 3
    Intermediate

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