USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Filter
|
|
|
File
|
|
|
Format
|
|
|
Find
|
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.
Detailed explanation-3: -Go to the Data tab in Excel and click on the Filter icon. Click on the small arrow next to the needed column name, go to Filter by Color and pick the correct cell color. Click OK and see all highlighted cells on top. Select the filtered colored cells, right-click on them and pick the Delete Row option from the menu.