Fill in the blank: A data professional at a junior college uses the spreadsheet _____ function to locate specific characters from a listing of course codes.
FROM
FIND
WHERE
IDENTIFY
A data analyst works with a spreadsheet containing product information that often has very long text strings. To check for consistency, they use a function to count the number of characters in cell P12. What is the correct syntax of the function?
\=LEN(P:P12)
\=LEN(P,12)
\=LEN(P:12)
=LEN(P12)
You use a spreadsheet to organize a list of upcoming tasks at work. Column A contains the list of tasks, and column B notes their priority: high, medium, or low. What spreadsheet tool will create a drop-down list of the priorities in column B?
Conditional formatting
Pop-up menus
Data validation
Find
An analyst at a weather station is analyzing data to understand how cloud cover affects temperature in their area. Currently, they have data on temperature in Celsius, but they want to convert this data to Fahrenheit. Which formula should they use to convert a Celsius value in cell G5 to Fahrenheit in another cell?
\=CONVERT(“F”, “C”, G5)
=CONVERT(G5, “C”, “F”)
\=CONVERT(“C”, “F”, G5)
\=CONVERT(G5, “F”, “C”)
You use a SQL database to evaluate rideshare efficiency. The database table contains one column of pick-up locations and another column of drop-off locations. What function will combine the pick-up and drop-off locations into a new column?
JOIN
GROUP
CONCAT
COMBINE
A data professional uses a spreadsheet to track the total purchases made by each member of the company’s procurement department. What spreadsheet tool can they use to change how the cells appear when someone has made more than $5,000 in purchases?
Data validation
Conditional formatting
CONVERT
Add color
Fill in the blank: A data professional analyzing gasoline prices uses the SQL function _____ to adjust the number $3.5698726 to just two decimal places.
SHORTEN
ROUND
DECIMAL
TRUNCATE
Spreadsheet cell H9 contains the text string
Tableau. To return the substringTab, what is the correct syntax?\=LEFT(3, H9)
\=RIGHT(3, H9)
=RIGHT(H9, 3)
\=LEFT(H9, 3)