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.

  • 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?

  • VIEW

Shuffle Q/A 3

29. When creating a SQL query, which JOIN clause returns all matching records in two or more database tables?

  • LEFT

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.

Leave a Reply