When you want to see all the data in a worksheet again, you can restore all the rows by clearing the filter. Click the filter arrow, and then click the ..... command.

WORKBOOK THEMES

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]

When you want to see all the data in a worksheet again, you can restore all the rows by clearing the filter. Click the filter arrow, and then click the ____ command.

A	Clear Filter From
B	Clear Filter To
C	Remove Filter From
D	Remove Filter To

Explanation:

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

Detailed explanation-2: -Click in your data, and then, in the Ribbon, select Home > Editing > Filter. Small drop down arrows will be applied to the header row of your data.

Detailed explanation-3: -You sort data to quickly organize your data and to find the data that you want. You filter data to display only the rows that meet criteria that you specify and hide rows that you do not want displayed, for one or more columns of data.

There is 1 question to complete.

FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

WORKBOOK THEMES