USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following commands will clear all filters in a worksheet?
|
|
Home tab, Editing group, Clear Formats
|
|
|
Data tab, Sort & Filter group, Clear
|
|
|
Data tab, Sort & Filter group, Filter
|
|
|
Home tab, Editing group, Sort & Filter, Filter
|
Explanation:
Detailed explanation-1: -If you want to completely remove filters, go to the Data tab and click the Filter button, or use the keyboard shortcut Alt+D+F+F.
Detailed explanation-2: -Clear all filters in a worksheet and redisplay all rows On the Home tab, in the Editing group, click Sort & Filter, and then click Clear.
There is 1 question to complete.