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?
A
TRIMCorrect Answer
B
NOSPACE
C
CUT
D
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.
A
RETURN
B
COUNTCorrect Answer
C
COUNT DISTINCT
D
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.
A
Perform the calculation more efficiently.
B
Ensure rows and columns do not change.Correct Answer
C
Create an absolute reference.Correct Answer
D
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
A
All records in the computer table and any matching rows from the equipment table
B
All rows from the equipment table joined together with the computer tableCorrect Answer
C
All records in the equipment table and any matching rows from the computer table
D
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 )
A
=VLOOKUP(Huron, A2:C10, false)
B
=VLOOKUP("Huron", A2:B10, 2, false)Correct Answer
C
=VLOOKUP(“Huron”, B2:C10, 2, false)
D
=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.
A
Subquery
B
Join
C
FilterCorrect Answer
D
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?
A
EXCHANGE
B
PROCESS
C
CONVERT
D
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
A
1 SELECTCorrect Answer
B
1 SELECTCorrect Answer
C
1 SELECT *Correct Answer
D
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.
A
Perform the calculation more efficiently.
B
Create an absolute reference.Correct Answer
C
Average the values in cells C1 to C100 regardless of whether the formula is copied.Correct Answer
D
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
A
All records in both the inventory table and the scrap table
B
All records in the inventory table and any matching rows from the scrap tableCorrect Answer
C
All records in the scrap table and any matching rows from the inventory table
D
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.
A
join
B
ORDER BY
C
AggregateCorrect Answer
D
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
A
1 SELECTCorrect Answer
B
1 SELECT *Correct Answer
C
1 SELECTCorrect Answer
D
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?
A
VALUE
B
NOSPACE
C
TRIMCorrect Answer
D
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.”
A
COUNTCorrect Answer
B
RANGE
C
RETURN
D
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.
A
Perform the calculation more efficiently
B
Sum the values in cells A6 to A60 regardless of whether the formula is copied.Correct Answer
C
Ensure rows and columns do not change.Correct Answer
D
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
A
All records in the biography table and any matching rows from the books table
B
All rows from the books table joined together with the biography table
C
All records in the books table and any matching rows from the biography tableCorrect Answer
D
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 )
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
A
1 SELECTCorrect Answer
B
1 SELECTCorrect Answer
C
1 SELECT *Correct Answer
D
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?
A
TRIMCorrect Answer
B
CUT
C
NOSPACE
D
VALUE
QUESTION 20 OF 23
In this spreadsheet, which function will search for the water type of Lake Urmia?
( Image S1Q20 )
A
=VLOOKUP(Urmia, A2:C10, 2, false)
B
=VLOOKUP(“Urmia”, A2:C10, 3, false)Correct Answer
C
=VLOOKUP(Urmia, A2:B10, false)
D
=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.
A
COUNTCorrect Answer
B
COUNT DISTINCT
C
RANGE
D
RETURN
QUESTION 22 OF 23
Fill in the blank: A SQL clause containing HAVING adds a filter to a _____ instead of the underlying table.
A
statement
B
column
C
row
D
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?
A
EXCHANGE
B
PROCESS
C
VALUECorrect Answer
D
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?