Week 3 – Aggregating data for analysis – Shuffle Q/A 2

21. The following is a selection from a spreadsheet:

To search for the population of Pakistan, what is the correct VLOOKUP syntax?

  • =VLOOKUP(Pakistan, A2*B10, 2, false)
  • =VLOOKUP(Pakistan, A2:B10, 3, false)
  • =VLOOKUP(“Pakistan”, A2:B10, 2, false)
  • =VLOOKUP(“Pakistan”, A2:B10, 3, false)

22. A data analyst writes the following query in SQL with the LEFT JOIN function:

FROM music_table

What does this function do?

  • It returns all records in the music table and only the records from the entertainment table with matching values.
  • It returns only the records with values that match from both tables.
  • It returns all the records in the entertainment table and only the record from the music table with matching values.
  • It returns all records in both the music table and the entertainment table.

23. When working with subqueries, which part of the query segment executes first?

  • The inner query
  • The smaller query
  • The outer query
  • The larger query

24. In data analytics, what is data aggregation?

  • The process of moving certain data points to a higher rank or position.
  • The process of modifying data in order to make it suitable for analysis.
  • The process of ensuring a company’s data is properly stored, managed, and maintained.
  • The process of gathering data from multiple sources and combining it into a single, summarized collection.

25. VLOOKUP can have problems when used on data values that have leading and trailing spaces. What function can be used to eliminate these spaces?

  • TRIM
  • CUT

26. You are using the VLOOKUP function in a specific column in your spreadsheet. You know that one of VLOOKUP’s limitations is that it can only search in columns to the right of the column into which it is entered. What can you do if you also want the function to search the data found to the left?

  • Use VLOOKUP in the leftmost column
  • Use VLOOKUP in the rightmost column
  • Copy that data into new columns to the right
  • Make the data into an absolute reference

27. A data analyst creates an absolute reference around a function array. What is the purpose of the absolute reference?

  • To automatically change numeric values to currency values
  • To keep a function array consistent so rows and columns will automatically change if the function is copied
  • To lock the function array so rows and columns don’t change if the function is copied
  • To copy a function and apply it to all rows and columns

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

  • LEFT

Shuffle Q/A 3

29. A data analyst is working with data that has been collected over time and stored in different databases. What process must they perform if they are to calculate the statistics of this data?

  • Data aggregation
  • Data mapping
  • Data grouping
  • Data composition

30. A data analyst uses the TRIM function on their spreadsheet. Why might they do this?

  • They plan to convert all numbers from text into numeric.
  • VLOOKUP needs data values to have leading spaces.
  • VLOOKUP needs data values to have trailing spaces.
  • They plan to use VLOOKUP on the spreadsheet data.

Devendra Kumar

Project Management Apprentice at Google

Leave a Reply