11. You are working with a SQL database that contains tables for the locations for a popular fast food restaurant. In this database, you have one column with the city location and another column with the state location for each restaurant. What function can you use in your query to combine the city and state into a new column?
- COMBINE
- CONCAT
- JOIN
- GROUP
12. Fill in the blank: A data analyst is working with a spreadsheet that has very long text strings. They use the LEN function to count the number of _____ in the text strings.
- substrings
- characters
- values
- fields
13. Spreadsheet cell H8 contains the text string “Marketing”. To return the substring “market”, what is the correct syntax?
- =RIGHT(6,H8)
- =LEFT(H8, 6)
- =RIGHT(H8, 6)
- =LEFT(6,H8)
14. You are querying a database of restaurant locations to determine how many fast food companies have restaurants located in Texas. For your project, you only need the first 20 records. What clause should you add to the following SQL query?
SELECT fast_food
FROM restaurant_table
WHERE location = “Texas”
- LIMIT,20
- LIMIT_20
- LIMIT 20
- LIMIT = 20
15. 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 B9. What is the correct syntax of the function?
- =LEN(B9)
- =LEN(“B9”)
- =LEN(B,9)
- =LEN(B:B9)
16. You are working with a data set that contains string data. Cell C4 contains the string “Oct 13, 2004”. What does the function FIND(“,”, C4) output?
- 4
- 6
- 8
- 7
17. An analyst notes that the “235” in cell B8 is formatted as text, but it should be Euros. What spreadsheet tool can help them select the right format?
- Format as Euros
- Format as Money
- Format as Number
- Format as Currency
18. A utility company uses a spreadsheet to track the number of consecutive months each customer has paid their bill on time. They use a spreadsheet tool to apply color to the cells when the number of consecutive months is 12 or greater. What tool are they using?
- Data validation
- Add color
- CONVERT
- Conditional formatting
Shuffle Q/A 2
19. Spreadsheet cell F2 contains the text string “Dashboard”. To return the substring “board”, what is the correct syntax?
- =LEFT(5,F2)
- =LEFT(F2, 5)
- =RIGHT(5,F2)
- =RIGHT(F2, 5)
20. You are using the FIND function to identify the position of the whitespace in the string in cell A6. Which of the following is the correct function syntax for this purpose?
- FIND(“_”, A6)
- FIND(A6, _ )
- FIND(A6, “ “)
- FIND(“ “, A6)
