DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
It is deleted
|
|
|
It is a different color
|
|
|
It is hidden
|
|
|
None of the above
|
Detailed explanation-1: -By filtering information in a worksheet, you can find values quickly. You can filter on one or more columns of data. With filtering, you can control not only what you want to see, but what you want to exclude.
Detailed explanation-2: -Filtered data displays only the rows that meet criteria that you specify and hides rows that you do not want displayed.
Detailed explanation-3: -Filtering Data When data is filtered, only rows that meet the filter criteria will display and other rows will be hidden. With filtered data, you can then copy, format, print, etc., your data, without having to sort or move it first.
Detailed explanation-4: -Filters can be used to narrow down the data in your worksheet and hide parts of it from view. While it may sound a little like grouping, filtering is different in the way that it allows you to qualify and display only the data that interests you.