21. Before completing a survey, an individual acknowledges reading information about how and why the data they provide will be used. What concept does this describe?
- Openness
- Consent
- Privacy
- Transaction transparency
22. A data analyst commits a SQL query to a repository as a new and improved query. Then, they specify the modifications they made during data cleaning and why they were made. What process does this scenario describe?
- Creating a changelog
- Data reporting
- Sharing results
- Data transferal
23. Fill in the blank: To remove leading, trailing, and repeated spaces when cleaning data, use the _____ function.
- EXTRACT
- CLEAN
- TRIM
- CLIP
24. Which spreadsheet tool changes how cells appear when values meet a specific condition?
- Data validation
- Protected ranges
- Conditional formatting
- Alternating colors
25. Fill in the blank: In a spreadsheet, the SPLIT function divides a text string around a ___ and puts each fragment into a new, separate cell.
- substring
- indicator
- delimiter
- mark
26. The date and time a photo was taken is an example of which kind of metadata?
- Descriptive
- Structural
- Administrative
- Representative
27. In spreadsheets, an absolute reference is used to lock a function array so that rows and columns don’t change if the function is copied. What symbol is used to create an absolute reference?
- Ampersand (&)
- Dollar sign ($)
- Asterisk (*)
- Hash (#)
28. Which spreadsheet function vertically searches for a certain value in a column in order to return a corresponding piece of information?
- VLOOKUP
- VALIDATE
- VALUE
- VIEW
Shuffle Q/A 3
29. When creating a SQL query, which JOIN clause returns all matching records in two or more database tables?
- RIGHT
- INNER
- LEFT
- OUTER
30. In a SQL query, which calculation does the modulo (%) operator perform?
- It applies an exponent to a value.
- It converts a decimal to a percent.
- It returns the remainder of a division calculation.
- It finds the square root of a number.