USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Displaying a subset of data that meets certain criteria and temporarily hiding data that does not meet that criteria.
|
Sort
|
|
Find
|
|
Filter
|
|
Fill
|
Explanation:
Detailed explanation-1: -Explanation : Filtering feature is mainly used to tentatively hide the data that does not meet the specified criteria required.
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: -filter refers to display only those data that meet with a specified criteria.
There is 1 question to complete.