FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

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.
A
Sort
B
Object
C
Conditional Formatting
D
Filtering
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: -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-3: -The FILTER function in Excel is used to filter a range of data based on the criteria that you specify.

There is 1 question to complete.