21. You are analyzing employee data for your company. In your SQL database, you have one column with the first names of the employees and another column with their last names. What function can you use in your query to combine the employee first names and last names into a new column?
- CONCAT
- COMBINE
- JOIN
- GROUP
22. An analyst is working with a dataset of financial data. The data is formatted as U.S. dollars, and the analyst needs it to be in Japanese yen. What spreadsheet tool can help them select the right format?
- Format as Currency
- Format as Money
- Format as Number
- Format as Yen
23. Which of the following are appropriate uses for a spreadsheet’s data validation tool? Select all that apply.
- Avoiding invalid inputs to functions
- Adding drop down menus on cells
- Merging two or more columns.
- Protecting structured data
24. You are working with a spreadsheet that records the running time of various songs. What spreadsheet tool can you use to change how the cells appear when their value is less than 20 seconds?
- CONVERT
- Data validation
- Conditional formatting
- Add color
25. A data analyst wants to write a SQL query to combine data from two columns and into a new column. What function can they use?
- GROUP
- CONCAT
- JOIN
- COMBINE
26. Fill in the blank: When working with spreadsheets, data analysts can use the _____ function to locate specific characters in a string.
- IDENTIFY
- FROM
- WHERE
- FIND
27. A data analyst at a symphony orchestra uses a spreadsheet to keep track of how many concerts require more than 80 musicians. They use a spreadsheet tool to change how cells appear when values equal 80 or more. What tool are they using?
- CONVERT
- Add color
- Conditional formatting
- Data validation
28. A data analyst is working with a spreadsheet that has very long text strings. They use a function to count the number of characters in cell G11. What is the correct syntax of the function?
- =LEN(“G11”)
- =LEN(G11)
- =LEN(G,11)
- =LEN(G:G11)
Shuffle Q/A 3
29. Spreadsheet cell C2 contains the text string “Deviation”. To return the substring “Dev”, what is the correct syntax?
- =LEFT(3,C2)
- =RIGHT(3,C2)
- =LEFT(C2, 3)
- =RIGHT(C2, 3)
30. When working with spreadsheets, data analysts use the find function to locate specific characters in a string. Find is case-sensitive, so it’s necessary to input the substring exactly how it appears.
- True
- False
