Data Filtering and Sorting Quiz

What is the primary purpose of using an auto filter in a dataset?

• To sort data in ascending order

• To highlight all data entries

• To view specific data entries based on criteria

• To permanently delete unwanted data

Which year is used as an example to demonstrate filtering by profit in the tutorial?

• 2014

• 2013

• 2012

• 2011

What condition is applied to filter profits using a standard filter in the tutorial?

• Profits not equal to 400 pounds

• Profits greater than or equal to 400 pounds

• Profits equal to 400 pounds

• Profits less than 400 pounds

In which months of 2013 did the profits exceed 400 pounds according to the tutorial?

• March, August, October, December

• January, February, March, April

• May, June, July, August

• September, October, November, December

Why are filters considered useful in data analysis?

• They allow for permanent data deletion

• They automatically generate data reports

• They help in visualizing data trends

• They enable viewing specific data entries in large datasets