FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Displaying a subset of data that meets certain criteria and temporarily hides other data
A
Filtering
B
Sorting
C
Conditional Formatting
D
Erasing
Explanation: 

Detailed explanation-1: -Answer: Data source filters are the correct answer.

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: -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.