USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
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 by Selection To see all the rows in a table that contain a value that matches the value in a row, you can quickly filter the datasheet view by selecting a specific value, and then clicking the Selection command. The drop-down list displays the available filtering options.
Detailed explanation-2: -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-3: -20. Selection FilterA filtering method that displays only records thatexactly match selected criteria.
There is 1 question to complete.