Data Management – Excel MCQs

By: Prof. Dr. Fazal Rehman Shamil | 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: