DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If you want to remove unwanted pieces of data from view in a table you can use this special feature.
|
|
Filter
|
|
|
File
|
|
|
Format
|
|
|
Find
|
Explanation:
Detailed explanation-1: -Select the tabular data as shown below. Select the “home” option and go to the “editing” group in the ribbon. The “clear” option is available in the group, as shown below. Select the “clear” option and click on the “clear formats” option.
Detailed explanation-2: -To create a data source filter Click Add to open an Add Filter dialog box listing all fields in the data source. Click to select a field to filter; then specify how the field should be filtered, just as you would for a field on the Filters shelf. To add an additional data source filter, repeat this procedure.
There is 1 question to complete.