Google Data Analytics Professional Certificate • STUDY MODE

PRACTICE QUIZ

QUESTION 1 OF 23

While using VLOOKUP, you encounter an error because some of your spreadsheet values have leading and trailing spaces. What function should you use to eliminate these spaces?

TRIMCorrect Answer

NOSPACE

CUT

VALUE

QUESTION 2 OF 23

Fill in the blank: The spreadsheet function _____ can be used to tally the number of cells in a range that are not empty.

RETURN

COUNTCorrect Answer

COUNT DISTINCT

RANGE

QUESTION 3 OF 23

A data analyst writes the following formula: =MAX($E$5:$E$500). What are the purposes of the dollar signs ($)? Select all that apply.

Perform the calculation more efficiently.

Ensure rows and columns do not change.Correct Answer

Create an absolute reference.Correct Answer

Find the maximum value in the range E5 to E500 regardless of whether the formula is copied.Correct Answer

QUESTION 4 OF 23

What will this query return? 1 SELECT * 2 FROM Equipment_table 3 LEFT JOIN Computer_table

All records in the computer table and any matching rows from the equipment table

All rows from the equipment table joined together with the computer tableCorrect Answer

All records in the equipment table and any matching rows from the computer table

All records in both the equipment table and the computer table

QUESTION 5 OF 23

In this spreadsheet, which function will search for the surface area of Lake Huron? ( Image S1Q5 )

=VLOOKUP(Huron, A2:C10, false)

=VLOOKUP("Huron", A2:B10, 2, false)Correct Answer

=VLOOKUP(“Huron”, B2:C10, 2, false)

=VLOOKUP(Huron, A2:B10, 3, false)

QUESTION 6 OF 23

Fill in the blank: A SQL clause containing HAVING adds a _____ to a query instead of the underlying table.

Subquery

Join

FilterCorrect Answer

Limit

QUESTION 7 OF 23

A data analyst at a retail store works with a spreadsheet containing sales data. In order to calculate sales tax correctly for customer orders, the analyst ensures all amounts are converted to numeric values. What function do they use?

EXCHANGE

PROCESS

CONVERT

VALUECorrect Answer

QUESTION 8 OF 23

Which query will select all columns from the operations table and alias them to ops? 2 FROM operations NEW ops 2 FROM operations TO ops 2 FROM operations AS ops 2 FROM operations ALIAS ops

1 SELECTCorrect Answer

1 SELECT *Correct Answer

1 SELECTCorrect Answer

QUESTION 9 OF 23

A junior data analyst writes the following formula: =AVERAGE($C$1:$C$100). What are the purposes of the dollar signs ($)? Select all that apply.

Perform the calculation more efficiently.

Create an absolute reference.Correct Answer

Average the values in cells C1 to C100 regardless of whether the formula is copied.Correct Answer

Ensure rows and columns do not change.Correct Answer

QUESTION 10 OF 23

What will this query return? 1 SELECT * 2 FROM Inventory_table 3 LEFT JOIN Scrap_table

All records in both the inventory table and the scrap table

All records in the inventory table and any matching rows from the scrap tableCorrect Answer

All records in the scrap table and any matching rows from the inventory table

All rows from the inventory table joined together with the scrap table

QUESTION 11 OF 23

Fill in the blank: A SQL clause containing HAVING can only be used with _____ functions.

join

ORDER BY

AggregateCorrect Answer

GROUP BY

QUESTION 12 OF 23

Which query will select all columns from the customers table and alias them to cust? 2 FROM customer TO cust 2 FROM customer AS cust 2 FROM customer NEW cust 2 FROM customer ALIAS cust

1 SELECTCorrect Answer

1 SELECT *Correct Answer

1 SELECTCorrect Answer

QUESTION 13 OF 23

You use VLOOKUP in a spreadsheet containing weather data. While searching for rainfall levels in Chicago, you encounter an error because your spreadsheet value has a trailing space after the city name. What function should you use to eliminate this space?

VALUE

NOSPACE

TRIMCorrect Answer

CUT

QUESTION 14 OF 23

Fill in the blank: The spreadsheet function _____ can be used to add up the number of times a range of cells contains the value “paid.”

COUNTCorrect Answer

RANGE

RETURN

COUNT DISTINCT

QUESTION 15 OF 23

A data professional writes the following formula: =SUM($A$6:$A$60). What are the purposes of the dollar signs ($)? Select all that apply.

Perform the calculation more efficiently

Sum the values in cells A6 to A60 regardless of whether the formula is copied.Correct Answer

Ensure rows and columns do not change.Correct Answer

Create an absolute reference.Correct Answer

QUESTION 16 OF 23

What will this query return? 1 SELECT * 2 FROM Books_table 3 LEFT JOIN Biography_table

All records in the biography table and any matching rows from the books table

All rows from the books table joined together with the biography table

All records in the books table and any matching rows from the biography tableCorrect Answer

All records in both the books table and the biography table

QUESTION 17 OF 23

In this spreadsheet, which function will search for the surface area of Lake Victoria? ( Image S1Q17 )

=VLOOKUP(“Victoria”, B2:C10, 2, false)

=VLOOKUP(Victoria, A2:B10, 3, false)

=VLOOKUP(“Victoria”, A2:B10, 2, false)Correct Answer

=VLOOKUP(Victoria, A2:C10, false)

QUESTION 18 OF 23

Which query will select all columns from the highways table and alias them to hwys? 2 FROM highways ALIAS hwys 2 FROM highways TO hwys 2 FROM highways AS hwys 2 FROM highways NEW hwys

1 SELECTCorrect Answer

1 SELECT *Correct Answer

1 SELECTCorrect Answer

QUESTION 19 OF 23

You use VLOOKUP to search for the name “Liza Campbell.” However, the function doesn’t work properly because your spreadsheet has a repeated space between the first and last name. What function should you use to eliminate this space?

TRIMCorrect Answer

CUT

NOSPACE

VALUE

QUESTION 20 OF 23

In this spreadsheet, which function will search for the water type of Lake Urmia? ( Image S1Q20 )

=VLOOKUP(Urmia, A2:C10, 2, false)

=VLOOKUP(“Urmia”, A2:C10, 3, false)Correct Answer

=VLOOKUP(Urmia, A2:B10, false)

=VLOOKUP(“Urmia”, B2:C10, 2, false)

QUESTION 21 OF 23

Fill in the blank: To find out how many times a specific error occurs in a range of cells, the spreadsheet function _____ can be used.

COUNTCorrect Answer

COUNT DISTINCT

RANGE

RETURN

QUESTION 22 OF 23

Fill in the blank: A SQL clause containing HAVING adds a filter to a _____ instead of the underlying table.

statement

column

row

queryCorrect Answer

QUESTION 23 OF 23

A junior data analyst in a marketing department works with a spreadsheet containing email click-through data. To calculate the average click-through rate for a campaign, the analyst uses a function to convert the number of clicks to numeric values. What function do they use?

EXCHANGE

PROCESS

VALUECorrect Answer

NUM

Ready to test your recall?

While using VLOOKUP, you encounter an error because some of your spreadsheet values have leading and trailing spaces. What function should you use to eliminate these spaces?

TRIM

NOSPACE

CUT

VALUE

How confident are you in this answer?