FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

ADJUSTING COLUMN WIDTH ROW HEIGHT 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 of the following should be applied if you want to display only rows which meet a certain specified criteria?

A	Icon set
B	Data bar
C	Filter
D	Sort

Explanation:

Detailed explanation-1: -Select the ranges you use, and click Data > Filter to enable the Filter function. 4. Click OK. Then only the rows which contain the text string you specified are displayed.

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: -Use the AutoFilter feature to find, show, or hide values-in one or more columns of data. You can filter based on choices you make from a list, or search to find the data that you seek. When you filter data, entire rows will be hidden if the values in one or more columns don’t meet the filtering criteria.

There is 1 question to complete.