1. The Sort feature in Excel is used to:
(A) Remove duplicates
(B) Arrange data in ascending or descending order
(C) Apply conditional formatting
(D) Validate data entry
2. By default, numbers in Excel are sorted in:
(A) Ascending order
(B) Descending order
(C) Random order
(D) Custom order
3. By default, text data in Excel is sorted in:
(A) Z to A
(B) Based on cell color
(C) A to Z
(D) Random order
4. Which tab in Excel contains the Sort and Filter options?
(A) Home
(B) View
(C) Review
(D) Data
5. Which option allows sorting data based on multiple columns?
(A) Quick Sort
(B) AutoFilter
(C) Custom Sort
(D) Find & Replace
6. The Filter feature in Excel is used to:
(A) Delete data
(B) Display only the rows that meet specific criteria
(C) Rearrange worksheets
(D) Format data automatically
7. After applying a Filter in Excel, filtered rows are:
(A) Deleted permanently
(B) Copied to another sheet automatically
(C) Hidden temporarily
(D) Converted to charts
8. Which of the following is NOT a filtering option in Excel?
(A) Image Filters
(B) Number Filters
(C) Date Filters
(D) Text Filters
9. The “Clear” option in the Filter menu is used to:
(A) Delete data from cells
(B) Lock the worksheet
(C) Sort data in ascending order
(D) Remove the filter and display all rows
10. Which shortcut key is used to apply AutoFilter in Excel?
(A) Ctrl + F
(B) Ctrl + Shift + L
(C) Ctrl + Alt + F
(D) Alt + D + F