(A) Excel cannot show you top 10 by using filters, you would have to sort the values in the column in descending order
(B) Excel can only highlight the top 10 values by using Conditional Formatting
(C) Click on the filter button, Number filters, Top 10, adjust to Top 3
(D) Click on the filter button, Number filters, Top 10, no adjustment for Top 3 only
If you choose the top 10 option on the filer button, Excel can show you the top 3 if you make an adjustment to the top 10 dialogue box. Sort and conditional formatting certainly are options, but filters can show you the top 3 items.
This question is from the Quiz section of the second lesson “Analyzing Data in Excel” from the HubSpot Excel for Marketers course. You can find answers to all the quiz questions asked in this course on our HubSpot Excel for Marketers Lesson Quiz Answers page.