Data Management – Excel MCQs

By: Prof. Dr. Fazal Rehman | Last updated: July 31, 2024

    1. Which Excel feature allows you to arrange data in a particular order? a) Filter b) Sort c) PivotTable d) Data Validation Answer: b) Sort
    2. What feature in Excel can be used to display only the rows that meet certain criteria? a) Sort b) Filter c) PivotTable d) Data Validation Answer: b) Filter
    3. Which tool in Excel provides a way to summarize large amounts of data quickly? a) Sort b) Filter c) PivotTable d) Data Validation Answer: c) PivotTable
    4. What feature would you use to restrict the type of data that can be entered in a cell? a) Sort b) Filter c) PivotTable d) Data Validation Answer: d) Data Validation
    5. Which function allows you to join text from two or more cells into one cell? a) CONCATENATE b) VLOOKUP c) HLOOKUP d) TEXTJOIN Answer: a) CONCATENATE and d) TEXTJOIN
    6. How can you ensure that a specific range of cells always contains unique values? a) Sort b) Filter c) PivotTable d) Data Validation with a custom rule Answer: d) Data Validation with a custom rule
    7. Which Excel feature helps in removing duplicate values from a dataset? a) Sort b) Filter c) Remove Duplicates d) Data Validation Answer: c) Remove Duplicates
    8. What feature would you use to quickly find specific data in a large dataset? a) Sort b) Filter c) Find and Replace d) Data Validation Answer: c) Find and Replace
    9. If you need to compare and analyze data from different perspectives, which Excel feature would be most useful? a) Sort b) Filter c) PivotTable d) Data Validation Answer: c) PivotTable
    10. Which function would you use to lookup and retrieve data from a specific column in a table? a) VLOOKUP b) HLOOKUP c) INDEX d) MATCH Answer: a) VLOOKUP and c) INDEX
    11. What feature in Excel allows you to split data into multiple columns based on a delimiter? a) Data Validation b) Text to Columns c) Filter d) PivotTable Answer: b) Text to Columns
    12. Which Excel tool can be used to automatically fill cells with data that follows a pattern? a) Sort b) Filter c) Flash Fill d) Data Validation Answer: c) Flash Fill
    13. To ensure data integrity by making sure entries conform to a specified pattern, which feature would you use? a) Sort b) Filter c) PivotTable d) Data Validation with a pattern rule Answer: d) Data Validation with a pattern rule
    14. Which function allows you to return the relative position of an item in an array that matches a specified value? a) VLOOKUP b) HLOOKUP c) INDEX d) MATCH Answer: d) MATCH
    15. What Excel feature allows you to group data based on specific intervals, such as dates or numbers? a) Sort b) Filter c) PivotTable d) Data Validation Answer: c) PivotTable

Related Posts:

All Copyrights Reserved 2025 Reserved by T4Tutorials