FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

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: -Filtered data displays only the rows that meet criteria that you specify and hides rows that you do not want displayed.

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

Detailed explanation-3: -filter refers to display only those data that meet with a specified criteria.

Detailed explanation-4: -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.

Detailed explanation-5: -Sorting is one of the most common tools for data management. In Excel, you can sort your table by one or more columns, by ascending or descending order, or do a custom sort.

There is 1 question to complete.