Chapter 4

What is the process of arranging data in a particular order?

• Sorting

• Goal seek

• Filtering

In which tab Advanced Filter option is available?

• Data

• Home

• View

In which group Sort option is available?

• View

• Data Tools

• Sort & Filter

Goal Seek option is present on _____ menu.

• Data

• Sort & Filter

• View

To remove a filter, click _______ option.

• Clear

• Autofilter

________ and _________ are two options for filtering data.

• Auto Filter, Advanced Filter

• Auto Filter, Sort & Filter

• Advanced Filter & Data

A Filter refers to display only those data that meet with a specified criteria.

• True

• False

Sorting only arranges the data in a decreasing order.

• True

• False

You cannot remove a Filter.

• True

• False

Sort & Filter group is not present in Data tab.

• True

• False