Discussion
In MS Excel, the AutoFilter feature allows you to
Answer: A
Correct answer: display only the rows that meet chosen criteria
AutoFilter, applied with Ctrl + Shift + L or from the Data tab, adds a drop-down arrow to each header and lets rows be hidden unless they meet the chosen criteria. It hides rather than deletes: clearing the filter brings everything back, and the row numbers turning blue with gaps in the sequence is the sign that a filter is active. Forgetting that is a common source of confusion, since a filtered sheet can look as though data has been lost. The filter offered depends on the column’s content. Text columns get Text Filters, with options such as begins with and contains; numeric columns get Number Filters, including Top 10 and Above Average; date columns get date-aware options such as Last Month. One caution worth knowing: functions such as SUM include hidden rows, whereas SUBTOTAL and AGGREGATE can be told to ignore them - which is why a filtered total should use SUBTOTAL.
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development