11. Fill in the blank: In the following spreadsheet, the feature sort range can be used to ________ the city names in column B?
- change
- alphabetize
- randomize
- delete
12. The function =AVERAGE(C2:C11) can be used to do what for the following spreadsheet?
- Arrange the rows according to increasing population size.
- Find the city with the largest population.
- Arrange the rows according to decreasing population size.
- Find the average population of the cities
13. 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 employee has the job title of Sales Manager?
- Nancy Edwards
- Margaret Park
- Michael Mitchell
- Andrew Adams
14. 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 40.
You write the SQL query below. Add a WHERE clause that will return only data about the customer with ID number 40.
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 40?
- Paris
- Dijon
- London
- Buenos Aires
15. A data analyst has to create a visualization that makes it easy to show which of the top ten most populous cities in North Carolina have a population below 250,000 people. What type of chart would be best for this visualization?
- Line chart
- Pie chart
- Bar chart
- Scatter chart
16. A data analyst wants to demonstrate how the population in Charlotte has increased over time. They create this data visualization. This is an example of an area chart.
- True
- False
17. In row 1 of the following spreadsheet, the words rank, name, population, and county are called what?
- Attributes
- Descriptors
- Criteria
- Characteristics
18. In the following spreadsheet, what feature was used to alphabetize the city names in column B?
- Organize range
- Sort range
- Name range
- Randomize range
Shuffle Q/A 2
19. To find the average population of the cities in this spreadsheet, you type =AVERAGE. What is the proper way to type the range that will complete your function?
- (C2,C11)
- (C2-C11)
- (C2:C11)
- (C2*C11)
20. You are working with a database table named playlist that contains data about playlists for different types of digital media. 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 playlist table.
What is the playlist with ID number 3?
- Audiobooks
- Music
- Movies
- TV Shows
