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