Data Manipulation (Data+) Filter Sort Aggregate Quiz

Submit

2. In data manipulation, what is the primary benefit of using indexes?

Reduces storage space required

Speeds up data retrieval and filtering operations

Automatically aggregates values

Prevents duplicate entries

Submit

4. Which SQL wildcard pattern matches any single character?

%

_

*

?

5. In data manipulation, what does normalization primarily accomplish?

Sorts data in reverse order

Scales values to a consistent range or standard format

Removes all null values

Combines multiple tables into one

6. Which aggregation function identifies the most frequently occurring value?

MEDIAN()

MODE()

STDDEV()

QUARTILE()

Submit

8. In SQL, which operator is used to filter rows where a value falls within a range?

LIKE

IN

BETWEEN

EXISTS

9. What is a pivot table primarily used for?

Sorting rows alphabetically

Summarizing and reorganizing data by categories

Removing duplicate entries

Validating data entry

10. Which function counts non-null values in a specified column?

SUM()

COUNT()

MAX()

LENGTH()

11. In SQL, which clause removes duplicate rows from query results?

DISTINCT

UNIQUE

REMOVE_DUPLICATES

GROUP BY

12. What does the HAVING clause filter in SQL?

Individual rows before aggregation

Aggregated groups after GROUP BY

Columns in the SELECT statement

Null values only

13. Which SQL clause combines results from multiple rows into a single summary row?

ORDER BY

HAVING

GROUP BY

LIMIT

14. In Excel, which feature allows you to display only rows meeting specific criteria?

Pivot Table

AutoFilter

Conditional Formatting

Data Validation

15. What is the difference between filtering and aggregating data?

Filtering removes rows; aggregating combines values into summaries

They perform identical functions

Aggregating removes rows; filtering combines values

Filtering requires more processing power

16. When using GROUP BY in SQL, what must you include in the SELECT clause?

All non-aggregated columns from GROUP BY

Only the primary key

Wildcard (*) for all columns

The table name

17. Which aggregation function returns the middle value in a sorted dataset?

MEDIAN()

MODE()

MEAN()

RANGE()

18. In data manipulation, what does the WHERE clause do?

Sorts rows alphabetically

Filters rows based on specified conditions

Groups similar values together

Joins two tables

19. Which SQL function calculates the total sum of numeric values in a column?

COUNT()

AVG()

SUM()

TOTAL()

20. What is the primary purpose of sorting data in ascending or descending order?

To reduce file size

To organize data for easier analysis and pattern recognition

To encrypt sensitive information

To automatically aggregate values

Data Manipulation Quiz: Can You Master Filter, Sort & Aggregate?

1. In data manipulation, a ____ operation arranges data in a specific sequence.

2.

What first name or nickname would you like us to use?

2. In data manipulation, what is the primary benefit of using indexes?

3. A ____ join combines rows from two tables based on a common column.

4. Which SQL wildcard pattern matches any single character?

5. In data manipulation, what does normalization primarily accomplish?

6. Which aggregation function identifies the most frequently occurring value?

7. The process of ____ involves identifying and removing irrelevant or incorrect data.

8. In SQL, which operator is used to filter rows where a value falls within a range?

9. What is a pivot table primarily used for?

10. Which function counts non-null values in a specified column?

11. In SQL, which clause removes duplicate rows from query results?

12. What does the HAVING clause filter in SQL?

13. Which SQL clause combines results from multiple rows into a single summary row?

14. In Excel, which feature allows you to display only rows meeting specific criteria?

15. What is the difference between filtering and aggregating data?

16. When using GROUP BY in SQL, what must you include in the SELECT clause?

17. Which aggregation function returns the middle value in a sorted dataset?

18. In data manipulation, what does the WHERE clause do?

19. Which SQL function calculates the total sum of numeric values in a column?

20. What is the primary purpose of sorting data in ascending or descending order?