DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Displays a subset of the data that meets certain criteria and temporarily hides the rows that do not meet the specified criteria.
|
|
Sort
|
|
|
Object
|
|
|
Conditional Formatting
|
|
|
Filtering
|
Explanation:
Detailed explanation-1: -The Excel AutoFilter feature allows you to narrow your data based on certain criteria and extract records that match those criteria. To turn on a filter, select the cells with data that you want to filter, click the Data tab in the Ribbon, and then click Filter.
Detailed explanation-2: -The FILTER function in Excel is used to filter a range of data based on the criteria that you specify.
Detailed explanation-3: -Filtering data is a quick and easy way to create a subset of data in a range of cells or in a table column. Filtered data displays only the rows that meet criteria that you specify and hides rows that you do not want to display. You can also filter by more than one column.
There is 1 question to complete.