31. A data analyst uses an absolute reference to lock a function array so rows and columns don’t change if the function is copied. What symbol is used to create an absolute reference?
- Ampersand (&)
- Asterisk (*)
- Dollar sign ($)
- Hashtag (#)
32. What are some of the advantages of using subqueries in SQL? Select all that apply.
- Subqueries can use special functions.
- The logic is easier to read and understand.
- All of the logic is in one place.
- The query processes more efficiently.
33. The VALUE function converts a numeric value into a text string in a spreadsheet.
- True
- False
34. A data analyst locks the rows and columns in their spreadsheet by wrapping their function’s data array in dollar signs ($). Why would they do this?
- To avoid incorrect calculations caused by changing the array
- So that the data auto deletes after the function is used
- So that other analysts’ functions can not access the arrayFeedback:
- To stop people from accessing sensitive information in the array
35. Which of the following terms describe a subquery? Select all that apply.
- Nested query
- Inner select
- Inner query
- Small query
36. The following is a selection from a spreadsheet:
To search for the growth in population in China, what is the correct VLOOKUP syntax?
- =VLOOKUP(China, A2*C10, 3, false)
- =VLOOKUP(China, A2:C10, 2, false)
- =VLOOKUP(“China”, A2:C10, 3, false)
- =VLOOKUP(“China”, A2:C10, 2, false)
37. You are exploring the employee retention rate for a department in your company. You realize that evaluating several other departments would also be a good idea. You decide to aggregate the data from all desired departments. What does this mean?
- You have modified the data from each source in order to make it suitable for analysis.
- You have collected the data from various sources into a single, summarized collection.
- You have investigated each of the various data sources individually and compared the results.
- You have ensured that the departments’ data is properly stored, managed, and maintained.
38. A data analyst writes a query in SQL. Inside this query, they have a second query. What is another name for the first query? Select all that apply.
- Outer query
- Central select
- Outer select
- Subquery
