DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following is used to show only the records according to given criteria?
|
|
Consolidate
|
|
|
Short
|
|
|
Filter
|
|
|
Pivot Tables
|
Explanation:
Detailed explanation-1: -Filter. Explanation: The data in a database is by filtering it. Filtering groups your data together based on one or more criteria for a given field, then displays only the records that contain those specified values and criteria.
Detailed explanation-2: -To filter for specific values, use the check box list.
Detailed explanation-3: -On the Home tab, in the Sort & Filter group, click Advanced and then click Advanced Filter/Sort on the shortcut menu. Add the fields on which you want to filter to the grid. In the Criteria row of each field, specify a criterion.
Detailed explanation-4: -20. Selection FilterA filtering method that displays only records thatexactly match selected criteria.
There is 1 question to complete.