Data Analytics Quiz -8

What is conditional filtering in Excel?

• Filtering data based on specified conditions

• Filtering data alphabetically

• Filtering data by date

• Filtering data by color

Which Excel feature is commonly used for conditional filtering?

• A. AutoSum

• B. PivotTables

• C. Data Validation

• D. AutoFilter

In Excel, what can you apply conditional filtering to?

• A. Numbers and dates

• B. Text and numbers

• C. Dates and text

• D. Formulas and functions

Which option allows you to create custom conditions for conditional filtering in Excel?

• A. AutoFilter

• B. Conditional Formatting

• C. Data Validation

• D. Sort & Filter

In Excel, how can you access the conditional filtering options?

• A. Right-click on the column header and choose "Filter."

• B. Click on the "Page Layout" tab.

• C. Press Ctrl+Shift+F.

• D. Go to the "Formulas" tab.

What does the "Top 10" filter option do in conditional filtering?

• A. Filters the top 10 rows of data

• B. Filters the top 10 unique values in a column

• C. Filters data based on the top 10 highest values

• D. Filters data based on the top 10 lowest values

Which logical operators can be used in creating custom conditions for conditional filtering?

• A. AND, OR, NOT

• B. PLUS, MINUS, EQUALS

• C. IF, THEN, ELSE

• D. SUM, AVERAGE, COUNT

In Excel, how can you clear conditional filters and show all the data again?

• A. Click on the "Clear Filter" button in the Filter dialog box.

• B. Select all the filtered cells and press Delete.

• C. Press Ctrl+Alt+Delete.

• D. Restart Excel.

Which Excel function can be used to count the number of visible (filtered) cells in a range?

• A. COUNT

• B. SUM

• C. SUBTOTAL

• D. AVERAGE

What is the keyboard shortcut to apply or remove conditional filters in Excel?

• A. Ctrl+F

• B. Alt+Shift+F

• C. Ctrl+Shift+L

• D. Ctrl+Alt+C