Filtering and Sorting

Full Name

Email ID

Student ID (Id No)

The rearrangement of data in ascending (A-Z) or descending (Z-A) orders is called__________ .

• Filtering

• Clear Rules

• Sorting

• Custom Filter

When data is arranged in ascending or descending order for only 1 column is called __________ .

• Multiple Column Sorting

• One Bar Sorting

• Single Column Sorting

• None of the Above

You want to sort a dataset first by "Region" (A-Z), then by "Salesperson" (A-Z), and finally by "Sales Amount" (largest to smallest). How can you achieve this in Excel?

• • Use Filter > Sort by Region, then by Salesperson, then by Sales Amount

• • Use Data > Custom Sort and add three levels of sorting

• Use Data > Custom list to add three Levels of Sorting

• All of these

The Sort & Filter option is present under which tab of Microsoft Excel?

• View Tab

• Insert Tab

• Data Tab

• Tools Tab

To quickly sort a list based on one column, on the Home tab , in the Editing group , click ___________ .

• Sort

• Filter

• Sort and Filter

• Review

You have selected a single cell in a range of data, and want to activate the filter command to filter rows out of the data set. Which characteristics must your data exhibit in order to filter correctly?

• A good header Row

• Consistent data types (e.g. text versus numbers) in the column

• Don’t know

• No entirely blank rows in the data set

Suppose column A contains a list of confectionery items. Which is the most efficient method to find anything containing “Chocolate”?

• Select the Filter and type “choc” in the search box

• Sort the data alphabetically and then visually scan down the lis

• Select the Filter, then click Text Filters and select Contains... and enter “Chocolate”

• Don’t know