Chapter 5 – Filter and Sort in Excel December 27, 2024 by Satish Dhawale Welcome to your Chapter 5 - Filter and Sort in Excel Name Email Phone 1. What is the purpose of Data Validation in Excel? To sort data To ensure data consistency To create formulas To format cells None 2. How do you apply Data Validation for a dropdown list in Excel? Select "Date" from the list Use the "List" option under Data Validation Use "Format Cells" Use "AutoFilter" option None 3. In older versions of Excel (2013/2016), how can you ensure unique values in a list for Data Validation? Manually remove duplicates Use Data Validation options Use COUNTIF function Use Remove Duplicates option None 4. What does the "IS EQUAL TO" condition in Excel Data Validation do? Compares data with another value Sorts data in descending order Filters data automatically Formats cells with a border None 5. Which of the following is used to sort data in Excel? SUM function Pivot Table Sort function Data Validation None 6. If you want to filter data for a specific state (e.g., Maharashtra) in Excel, which function will you use? VLOOKUP FILTER function CONCATENATE function SUMIFS function None 7. How do you sort data in Excel by a specific column in descending order? Use the Sort function and choose Ascending Use the Filter function Use the Sort function and choose Descending Use Data Validation options None 8. How do you extract the top 5 records based on a specific criterion (e.g., highest sales) in Excel? Use VLOOKUP and SORT Use the SORT function with FILTER Use CONCATENATE and FILTER Use the COUNTIF function None 9. What is the effect of using "Not Found" in the Data Validation error message in Excel? It highlights the invalid data It provides a dropdown list It prevents data entry that doesn't match a given condition It sorts data alphabetically None 10. In Excel, how can you count the number of columns in a dataset? Use the COUNTA function Use the COLUMNS function Use the COUNTIF function Use the COUNT function None Time's upTime is Up! Post Views: 5,369
