..... is a quick and easy way to find and worked with subset in a data list

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

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]

____ is a quick and easy way to find and worked with subset in a data list

A	Sorting
B	Filtering
C	Spelling
D	Subtotals

Explanation:

Detailed explanation-1: -The “AutoFilter” or “Sort and Filter” function in Excel allows you to create views of data matching your specified criteria. The subset will show only the rows you wish to see. You can perform several functions on the filtered subset of the data without needing to copy and paste the data into a new worksheet.

Detailed explanation-2: -On the Home tab, in the Sort & Filter group, click Advanced and then click Advanced Filter/Sort on the shortcut menu. Add the fields on which you want to filter to the grid.

Detailed explanation-3: -AutoFilter is a function that allows you to view and subset your data easily and quickly without making any permanent changes to your data. You can filter your data by selecting your worksheet or the portion of your worksheet of interest.

There is 1 question to complete.

FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS