Google Data Analytics Professional Certificate

You are working with a database table that contains invoice data. The customer_id column lists the ID number for each customer. You are interested in invoice data for the customer with ID number 7. You write the SQL query below. Add a WHERE clause that will return only data about the customer with ID number […]

In the following spreadsheet, the feature sort range was used to do what? Randomize the rank Randomize the population Alphabetize column B Alphabetize column D

A data analyst has to demonstrate how the population in Charlotte has increased over time. They create the chart below. What is this type of chart called? Area chart Column chart Line chart Bar chart

The function =AVG_pop(C2:C11) will calculate the average population across the cities in this spreadsheet. True False

Fill in the blank: A data analyst has to demonstrate how the population in a city has increased over time. In particular, they want to be able to see when the population has exceeded certain thresholds. The chart that would work best for this is a/an _____ chart. area line bar column

You are working with a database table that contains invoice data. The customer_id column lists the ID number for each customer. You are interested in invoice data for the customer with ID number 50. You write the SQL query below. Add a WHERE clause that will return only data about the customer with ID number

To find the average population of the cities in this spreadsheet, what is the correct AVERAGE function syntax? Type your answer below. AVERAGE(C2-C11) =AVERAGE(C2-C11) =AVERAGE(C2:C11) AVERAGE(C2:C11)

A company is curious about the population trend in Charlotte, NC. A data analyst in the company is tasked with creating a visualization that depicts such information. What type of chart would be best for this task and why? A pie chart because it plots a sequence of points and connects them with straight lines

In the following spreadsheet, the observation of Greensboro describes all of the data in row 4. True False

A data analyst wants to list the cities in this spreadsheet alphabetically, instead of numerically. They can use the feature sort range to do this. True False