FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which tool is used to only show data that meets specific criteria and hides the rest of the data?

A	Hide
B	Sort
C	Filter
D	AutoFilter

Explanation:

Detailed explanation-1: -Answer. Answer: In addition to sorting, you may find that adding a filter allows you to better analyze your data. When data is filtered, only rows that meet the filter criteria will display and other rows will be hidden.

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

Detailed explanation-3: -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-4: -The correct answer is Filter. The Excel FILTER feature filters a collection of data based on the criteria supplied and extracts matching information. The Excel FILTER feature “filters” a set of data based on the criteria supplied.

Detailed explanation-5: -Answer: Answer: If the data you want to filter requires complex criteria (such as Type = “Produce” OR Salesperson = “Davolio"), you can use the Advanced Filter dialog box.

There is 1 question to complete.