Chapter 05. Sorting and Filters in Excel - V
Chapter 5: Sorting and Filters in Excel
Fill-in-the-Blank Questions
1) ________ allows you to arrange data in ascending or descending order.
Answer: Sorting
2) A ________ is used to display only the rows that meet specific criteria.
Answer: Filter
3) The shortcut key for opening the filter menu is ________.
Answer: Alt + Down Arrow
4) You can apply filters to multiple ________ at the same time.
Answer: Columns
5) Sorting options can be accessed under the ________ tab in Excel.
Answer: Data
6) ________ sorting arranges values from smallest to largest.
Answer: Ascending
7) Excel allows you to filter data by ________ color.
Answer: Cell
8) The ________ tool is used to remove all filters at once.
Answer: Clear Filter
9) ________ sorting uses more than one column to organize data.
Answer: Multi-level
True/False Questions
1] Sorting data alphabetically in Excel is possible.
Answer: True
2] Filters can only be applied to numeric data.
Answer: False
3] Excel allows you to sort data by cell color.
Answer: True
4] You can use filters to show only cells with blank values.
Answer: True
5] Data sorting is case-sensitive by default in Excel.
Answer: False
6] Filters can use custom criteria to display specific rows.
Answer: True
7] You cannot filter by date in Excel.
Answer: False
8] You can sort data without modifying the original dataset.
Answer: False
9] Filters automatically update when the data changes.
Answer: True
Answer the Following
1) What does sorting do in Excel?
Answer: It arranges data in ascending or descending order.
2) What is the purpose of a filter?
Answer: It displays only rows that meet specific criteria.
3) Can Excel filter data by cell color?
Answer: Yes, it can filter by cell or font color.
4) How do you remove all filters in Excel?
Answer: Use the "Clear Filter" option.
5) What is multi-level sorting?
Answer: It sorts data based on more than one column.
Comments
Post a Comment