Ask a question for free
Computer Science

The __________ feature in Excel will Decideto highlight the Top 10% marks in the class.​

answers: 1
Register to add an answer


Select the cell that contains the results to filter. In this example, we have selected the Order ID field which is cell A1 (we want to show the top 10 Order IDs based on the "Sum of Quantity").

Microsoft Excel

Click on the arrow to the right of the Order ID drop down box and select Value Filters > Top 10 from the popup menu.

When the Top 10 Filter (Order ID) window appears, select Top, 10, Items, and Sum of Quantity in the respective drop downs. Then click on the OK button.

Now when you view your pivot table, you should only see the top 10 Order IDs based on the Sum of Quantity.

For answers need to register.
Expert in study
About us
For new users
For new experts
Terms and Conditions