31. You are working with a database table named employee that contains data about employees. You want to review all the columns in the table.
You write the SQL query below. Add a FROM clause that will retrieve the data from the employee table.
What is the job title of Andrew Adams?
- General Manager
- Sales Manager
- Sales Support Agent
- IT Manager
32. Fill in the blank: Suppose you wanted to determine the average population of the cities in the following spreadsheet. The correct function syntax to use would be ________ .
- =AVERAGE(C2-C11)
- AVERAGE(D2:D11)
- AVERAGE(C2:C11)
- =AVERAGE(C2:C11)
33. 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
34. In the following spreadsheet, the observation of Greensboro describes all of the data in row 4.
- True
- False
35. 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 or curves.
- A line chart because it plots a sequence of points and connects them with straight lines or curves.
- A line chart because it is a visualization that uses a circle which is divided into wedges sized based on numerical proportion.
- A bar chart because it is a visualization that represents data with columns, or bars, the heights of which are proportional to the values that they represent.
36. 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)
37. 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 50.
After you run your query, use the slider to view all the data presented.
What is the billing city for the customer with ID number 50?
- Paris
- Bangalore
- Tokyo
- Madrid
38. 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
Shuffle Q/A 4
39. The function =AVG_pop(C2:C11) will calculate the average population across the cities in this spreadsheet.
- True
- False
40. 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
