Sorting and filtering data – Excel MCQs

  1. Which Excel feature allows you to arrange data in ascending or descending order?
    a) Filter
    b) Sort
    c) PivotTable
    d) Data Validation
    Answer: b) Sort
  2. What is the primary use of the Filter feature in Excel?
    a) To arrange data in a specific order
    b) To hide rows that do not meet certain criteria
    c) To create charts
    d) To perform calculations
    Answer: b) To hide rows that do not meet certain criteria
  3. How do you access the Sort and Filter options in Excel?
    a) File tab
    b) Home tab
    c) Data tab
    d) Insert tab
    Answer: c) Data tab
  4. Which option would you use to sort data by more than one column in Excel?
    a) Filter
    b) Custom Sort
    c) Quick Sort
    d) Sort Ascending
    Answer: b) Custom Sort
  5. When you apply a filter in Excel, what happens to the rows that do not meet the criteria?
    a) They are deleted
    b) They are hidden
    c) They are moved to a new sheet
    d) They are highlighted
    Answer: b) They are hidden
  6. Which button is used to clear all filters applied to a dataset in Excel?
    a) Clear All
    b) Reset
    c) Filter Off
    d) Clear Filter
    Answer: d) Clear Filter
  7. How can you sort a column in Excel from highest to lowest values?
    a) Sort A to Z
    b) Sort Z to A
    c) Custom Sort
    d) Filter
    Answer: b) Sort Z to A
  8. What does the “Sort by Color” feature in Excel allow you to do?
    a) Sort cells based on their fill color
    b) Sort cells based on their font color
    c) Both a and b
    d) Neither a nor b
    Answer: c) Both a and b
  9. Which of the following is true about the Filter feature in Excel?
    a) It can only be applied to numeric data
    b) It can filter data based on multiple criteria
    c) It permanently deletes filtered data
    d) It cannot be used with text data
    Answer: b) It can filter data based on multiple criteria
  10. If you want to quickly sort a column of dates from oldest to newest, which option should you use?
    a) Sort Z to A
    b) Sort A to Z
    c) Sort Oldest to Newest
    d) Sort Newest to Oldest
    Answer: c) Sort Oldest to Newest
  11. Which type of data cannot be sorted using the Sort feature in Excel?
    a) Text
    b) Numbers
    c) Dates
    d) Images
    Answer: d) Images
  12. What is the first step to apply a filter to a range of data in Excel?
    a) Select the range of data
    b) Click on the Insert tab
    c) Open the Review tab
    d) Select the Home tab
    Answer: a) Select the range of data
  13. How can you filter data to show only rows that contain a specific text string?
    a) Use Sort A to Z
    b) Use Custom Filter
    c) Use Data Validation
    d) Use Conditional Formatting
    Answer: b) Use Custom Filter
  14. Which feature allows you to sort data based on a custom list, such as sorting months in chronological order?
    a) Custom Sort
    b) Filter
    c) Sort by Color
    d) Data Validation
    Answer: a) Custom Sort
  15. What happens when you click the “Sort Largest to Smallest” button in a column of numbers?
    a) The numbers are sorted in ascending order
    b) The numbers are sorted in descending order
    c) The numbers are filtered out
    d) The numbers are averaged
    Answer: b) The numbers are sorted in descending order

Related Posts: