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
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
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
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
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
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
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
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
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
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
Which type of data cannot be sorted using the Sort feature in Excel?
a) Text
b) Numbers
c) Dates
d) Images
Answer: d) Images
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
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
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
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
