FTC Data Week 10

What is filtering in data analysis?

• Removing all unnecessary data from a dataset

• Narrowing down a dataset to include or exclude specific information based on criteria

• Sorting data in ascending or descending order

• Replacing missing values with estimated values

Why is filtering important in data analysis?

• It removes all errors from the dataset

• It simplifies data entry tasks

• It helps focus on relevant data and identify trends

• It ensures all data is included in the analysis

Which of the following is an example of filtering by inclusion?

• Hiding all sales data except for Q1

• Removing duplicate values from a dataset

• Deleting rows with missing values

• Sorting data by alphabetical order

When should you use exclusion filtering?

• When you want to remove outliers that distort analysis

• When you want to highlight key data categories

• When you need to duplicate data for comparison

• When you are sorting data in Power BI

What does the VLOOKUP function do in Excel?

• Looks for a value in the first column of a table and returns a corresponding value from another column

• Searches for a value in a row and returns a corresponding value from another row

• Sorts data in ascending order

• Filters data based on specific conditions

What is the key difference between VLOOKUP and HLOOKUP?

• VLOOKUP searches in columns, while HLOOKUP searches in rows

• HLOOKUP is faster than VLOOKUP

• VLOOKUP can search in both columns and rows

• HLOOKUP only works with numerical data

Which of the following functions returns the position of a value in a range?

• INDEX

• VLOOKUP

• MATCH

• FILTER

How does the INDEX function work in Excel?

• It finds a value in a dataset and returns its row number

• It returns a value from a specified row and column in a given range

• It sorts data in alphabetical order

• It replaces missing values with estimated ones

Which of the following is a best practice when applying filters?

• Use as many filters as possible to refine data

• Avoid over-filtering to ensure trends are not obscured

• Always use exclusion filtering instead of inclusion filtering

• Do not document applied filters

How can you apply a simple filter in Excel?

• Use the VLOOKUP function

• Use the Filter option in the Data menu

• Type “FILTER” in the search bar

• Use the Sort function