Google Data Analytics Professional Certificate • STUDY MODE
PRACTICE QUIZ
QUESTION 1 OF 20
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.
A
IDENTIFY
B
FROM
C
FINDCorrect Answer
D
WHERE
QUESTION 2 OF 20
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?
A
=LEN(P,12)
B
=LEN(P:12)
C
=LEN(P:P12)
D
=LEN(P12)Correct Answer
QUESTION 3 OF 20
You prepare a project tracker spreadsheet. Next to each project is the name of the team member responsible. What spreadsheet tool will create a drop-down list with team member names to save you time when assigning the projects?
A
Data validationCorrect Answer
B
Conditional formatting
C
Find
D
Pop-up menus
QUESTION 4 OF 20
An analyst works with a dataset of financial data that is formatted in U.S. dollars. However, it should be formatted as Japanese yen. What spreadsheet tool should they use to correct the format?
A
Format as currencyCorrect Answer
B
Format as yen
C
Format as money
D
Format as amount
QUESTION 5 OF 20
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?
A
COMBINE
B
GROUP
C
JOIN
D
CONCATCorrect Answer
QUESTION 6 OF 20
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?
A
Conditional formattingCorrect Answer
B
CONVERT
C
Add color
D
Data validation
QUESTION 7 OF 20
Fill in the blank: A junior data analyst working with interest rate data uses the SQL function _____ to adjust 6.23456789012345678901234567890% to just one decimal place.
A
SHORTEN
B
DECIMAL
C
TRUNCATE
D
ROUNDCorrect Answer
QUESTION 8 OF 20
Spreadsheet cell L2 contains the text string Function. To return the substring Fun, what is the correct syntax?
A
=LEFT(L2, 3)Correct Answer
B
=RIGHT(3, L2)
C
=LEFT(3, L2)
D
=RIGHT(L2, 3)
QUESTION 9 OF 20
A data analyst works with a spreadsheet containing medical record numbers that must be exactly 30 digits long. To ensure accuracy, they use a function to count the number of characters in cell H10. What is the correct syntax of the function?
A
=LEN(30)
B
=LEN(H10, 30)
C
=LEN(H10)Correct Answer
D
=LEN(30, H10)
QUESTION 10 OF 20
You use a spreadsheet to help you with an upcoming gift exchange. Every time you find an interesting gift idea, you add it to the spreadsheet. What spreadsheet tool will create a drop-down list with Need to Purchase and Purchased as the possible options?
A
Conditional formatting
B
Pop-up menus
C
Find
D
Data validationCorrect Answer
QUESTION 11 OF 20
An analyst works with financial data that is formatted as Euros, but it should be formatted as pesos. What spreadsheet tool should they use to correct the format?
A
Format as Euros
B
Format as money
C
Format as currencyCorrect Answer
D
Format as peso
QUESTION 12 OF 20
You use a SQL database to analyze airline flight routes in Africa. The database table contains one column of departure airports and another column of arrival airports. What function will combine the departure and arrival airport names into a new column?
A
JOIN
B
CONCATCorrect Answer
C
COMBINE
D
GROUP
QUESTION 13 OF 20
A data analyst at a symphony orchestra uses a spreadsheet to track how many concerts require more than 65 musicians. What spreadsheet tool can they use to change how cells appear when values equal 65 or more?
A
Conditional formattingCorrect Answer
B
Data validation
C
Add color
D
CONVERT
QUESTION 14 OF 20
Spreadsheet cell H9 contains the text string Tableau. To return the substring Tab, what is the correct syntax?
A
=LEFT(3, H9)
B
=RIGHT(H9, 3)
C
=RIGHT(3, H9)
D
=LEFT(H9, 3)Correct Answer
QUESTION 15 OF 20
Fill in the blank: A data analyst at a logistics company uses the spreadsheet _____ function to locate specific characters from a shipping confirmation email.
A
IDENTIFY
B
WHERE
C
FROM
D
FINDCorrect Answer
QUESTION 16 OF 20
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?
A
Data validationCorrect Answer
B
Pop-up menus
C
Conditional formatting
D
Find
QUESTION 17 OF 20
A data analyst in human resources uses a spreadsheet to track employee work anniversaries. What spreadsheet tool can they use to add color to the cells containing the name of any employee who has worked for the business for at least five years?
A
Conditional formattingCorrect Answer
B
Data validation
C
CONVERT
D
Add color
QUESTION 18 OF 20
Fill in the blank: A data analyst analyzing the boiling points of various liquids uses the SQL function _____ to adjust 356.727801 °C to just three decimal places.
A
DECIMAL
B
ROUNDCorrect Answer
C
SHORTEN
D
TRUNCATE
QUESTION 19 OF 20
An analyst notes that the “85” in cell A3 is formatted as text, but it should be Australian dollars. What spreadsheet tool should they use to correct the format?
A
Format as currencyCorrect Answer
B
Format as money
C
Format as dollars
D
Format as amount
QUESTION 20 OF 20
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.
A
ROUNDCorrect Answer
B
DECIMAL
C
TRUNCATE
D
SHORTEN
Ready to test your recall?
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.