11. You create a function using data values from a specified array. You notice that it works correctly only some of the time. You verify that the function was used correctly and you ask a colleague for their input. They ask if you locked the data array. What does this mean? Select all that apply.
- The data array has been made an absolute reference.
- The columns in the array cannot be changed.
- The data is accessible with a password.
- The rows in the array cannot be changed.
12. The following is a selection from a spreadsheet:
To search for the population of Bangladesh, what is the correct VLOOKUP syntax?
- =VLOOKUP(“Bangladesh”, A2:B10, 3, false)
- =VLOOKUP(Bangladesh, A2:B10, 3, false)
- =VLOOKUP(“Bangladesh”, A2:B10, 2, false)
- =VLOOKUP(Bangladesh, A2*B10, 2, false)
13. A data analyst writes a query in SQL with the RIGHT JOIN function
FROM fiction_table
RIGHT JOIN
books_table
What does this function do?
- It returns all the records in the fiction table and only the records from the books table with matching values.
- It returns all records in both the fiction table and the books table.
- It returns only the records with values that match from both tables.
- It returns all records in the books table and only the records from the fiction table with matching values.
14. The COUNT DISTINCT function includes repeating values when returning values in a specified range.
- True
- False
15. A data analyst writes a query in SQL. Inside this query, they have a second query. What is this second query called? Select all that apply.
- Subquery
- Central query
- Smaller query
- Nested query
16. One of the limitations of the VLOOKUP function is that it can only search columns to the right of the column into which it is entered. What is another limitation of VLOOKUP?
- It will only return the last match it finds.
- It can only be used on numerical data.
- It can only be used with text data.
- It will only return the first match it finds.
17. A data analyst wraps the data array for their function in dollar signs ($). What does this do? Select all that apply.
- It converts the data to currency.
- It makes it so that columns cannot be changed.
- It makes it so that rows cannot be changed.
- It creates an absolute reference.
18. The following is a selection from a spreadsheet:
To search for the population of Brazil, what is the correct VLOOKUP syntax?
- =VLOOKUP(“Brazil”, A2:B10, 2, false)
- =VLOOKUP(Brazil, A2:B10, 2, false)
- =VLOOKUP(Brazil, A2,B10, 3, false)
- =VLOOKUP(Brazil, A2:B10, 3, false)
Shuffle Q/A 2
19. You are writing a query that contains the COUNT function. What should this query return?
- The number of rows in a specified range
- The number of times the query has been run
- The sum of all values in a specified range
- The number of columns in a specified range
20. A data analyst wants to be sure all of the numbers in a spreadsheet are numeric. What function should they use to convert text to numeric values?
- VALUE
- PROCESS
- CONVERT
- EXCHANGE
