Week 4: Set Up Your Toolbox
Set Up Your Toolbox INTRODUCTION
In this section of the Coursera Google Data Analytics Professional Certification course, you’ll learn how to build your data analysis toolbox. You’ll begin with the fundamentals of spreadsheets and query languages, exploring essential functions like sorting and filtering data. Additionally, you’ll delve into data visualization tools, including charts, tables, and graphs.
You’ll also gain practical experience in creating impactful visualizations that support business decision-making. By mastering these skills, you’ll be equipped to tackle a wide range of challenges as a data analyst. Let’s dive in!
Learning Objectives
- Define spreadsheets, query languages, and data visualization tools with clear examples.
- Demonstrate knowledge of spreadsheet uses, key features, and functions.
- Explain core SQL concepts, including examples of common queries.
- Understand the basics of data visualization and provide specific examples.
Test your knowledge on Spreadsheet basic
1. In a spreadsheet, what is text wrapping used for?
- To clip text within a cell so it doesn’t overflow into an adjacent cell
- To allow all of the text to fit inside a cell (Correct)
- To allow text to overflow into an adjacent cell
- To remove text that is too long to fit in a cell
Correct: In a spreadsheet, text wrapping is used to allow all of the text to fit inside a cell.
2. The columns in a spreadsheet are ordered by letter, and the rows are ordered by number.
- True (Correct)
- False
Correct: In a spreadsheet, columns are ordered by letter and rows are ordered by number.
3. Fill in the blank: In a data table, a row is called an observation. An observation includes all of the _____ for what is contained in the row.
- names
- commonalities
- attributes (Correct)
- diagnostics
Correct: In a Information table each row is referred to as an observation. associate in nursing notice represents complete the attributes joint with amp particular debut inch the Informationset. An attribute refers to a quality or characteristic of the Information contained in the row.
Test your knowledge on sql
1. What does the asterisk (*) after SELECT tell the database to do in this query?
- Select all data that meets the criteria as stated in the query
- Select all data that meets the criteria as stated in the query, then multiply it
- Select the LastName column from the employee table
- Select all columns from the employee table (Correct)
Correct: The SELECT * statement instructs the database to retrieve all columns from the employee table. The criteria specified in the WHERE clause define the conditions that determine which rows of data the query should return.
2. In this query, the data analyst wants to retrieve data from which table?
- LastName
- jobCode
- James
- employee (Correct)
Correct: The data analyst wants to retrieve data from the employee table
3. In this query, what will be retrieved from the database?
- All data from the employee table, where the jobCode is FTE and the last name is James. (Correct)
- All data from the employee table, where the jobCode is FTE and the employee has any last name other than James.
- All data from the jobCode table, where the jobCode is FTE and the employee has any last name other than James.
- All data from the FTE table, where the employee’s LastName is James.
Correct: This query will select all data from the employee table, where the jobCode is FTE and the last name is James.
4. You are working with a database table that contains data about music artists. The table is named artist. 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 artist table.
How many columns are in the artist table?
- 9
- 5
- 2 (Correct)
- 8
Correct: The clause FROM artist specifies that the Information should be retrieved from the artist table. the over question take * from creative person leave find complete columns from the board. In this case the artist table contains two columns.
5. You are working with a database table that contains data about music albums. You are only interested in data related to the album with ID number 277. The album IDs are listed in the album_id column from the album table.
You write the SQL query below. Add a WHERE clause that will return only data about the album with ID number 277.
What is the name of the album with ID number 277?
- Vivaldi: The Four Seasons
- Beethoven: Piano Sonatas
- Mozart: Chamber Music
- Bach: Goldberg Variations (Correct)
Correct: The clause WHERE album_id = 277 filters the results to include only data about the album with an ID of 277. The complete query, SELECT * FROM album WHERE album_id = 277, retrieves all columns for the specified album. The WHERE clause specifies conditions by including the column name, a comparison operator (e.g., =), and the value to match. In this case, the album with ID 277 is titled Bach: Goldberg Variations.
Test Your Knowledge on Visualizing Data
1. Fill in the blank: A data visualization is the _____ representation of information.
- tabulated
- attributed
- contextual
- graphical (Correct)
Correct: A data visualization is the graphical representation of information.
2. When would a pie chart be an effective visualization? _____.
- When showing a change in someone’s age over time
- When showing the ages of males versus females
- When showing the relationship between age and income
- When showing a class broken down by age (Correct)
A pie chart illustrates how a whole is divided into parts and is an effective visualization for displaying a class distribution by age groups.
3. What are the key benefits of data visualizations? Select all that apply.
- They can illustrate relationships between data points (Correct)
- They can ensure that you get fewer questions about your analysis
- They can help stakeholders understand complex data more quickly (Correct)
- They can clearly demonstrate patterns and trends (Correct)
Data visualizations effectively highlight patterns and trends, enable stakeholders to quickly comprehend complex information, and showcase relationships between data points.
Set Up Your Toolbox Weekly Challenge 4
1. In row 1 of the following spreadsheet, the words rank, name, population, and county are called what?
| A | B | C | D | |
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
- Criteria
- Descriptors
- Characteristics
- Attributes (Correct)
Correct: These words are attributes, referring to the information in the columns below. An attribute is a characteristic or quality of data used to label a column in a table.
2. In the following spreadsheet, where can you find all of the attributes—also known as the observation—of Fayetteville?
- Cell B7
- Row 6
- Column B
- Row 7 (Correct)
Correct: The observation for Fayetteville is located in row 7. An observation encompasses all the attributes or characteristics associated with a single entry in a row of a data table.
3. In the following spreadsheet, what feature was used to alphabetize the city names in column B?
- Name range
- Sort range (Correct)
- Randomize range
- Organize range
Correct: Sort range was used to alphabetize the city names in column B. Sorting a range of data from A to Z helps data analysts organize and find data more quickly.
4. 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 (Correct)
- C2,C11
- C2-C11
- C2*C11
Correct: The range is C2:C11. The full AVERAGE function syntax is =AVERAGE(C2:C11). AVERAGE returns an average of values from a selected range. C2:C11 is the specified range.
5. You are working with a database table named employee that contains data about employees. You want to review all the columns in the table.
What employee has the job title of Sales Manager?
- Margaret Park
- Michael Mitchell
- Andrew Adams
- Nancy Edwards (Correct)
The clause FROM employee retrieves data from the employee table. The complete query, SELECT * FROM employee, selects all columns from this table. The FROM clause specifies the database table to query. In this case, the employee Nancy Edwards holds the job title of Sales Manager.
6. 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 28.
You write the SQL query below. Add a WHERE clause that will return only data about the customer with ID number 28.
What is the billing city for the customer with ID number 28?
- Dijon
- Salt Lake City (Correct)
- Bangalore
- Buenos Aires
The clause WHERE customer_id = 28 filters the data to return only information about the customer with ID number 28. The complete query, SELECT * FROM invoice WHERE customer_id = 28, retrieves all columns from the invoice table for that specific customer. The WHERE clause specifies the conditions to filter the results, which include the column name, an equals sign, and the value to match. In this case, the billing city for the customer with ID number 28 is Salt Lake City.
7. A data analyst creates the following visualization to clearly demonstrate how much more populous Charlotte is than the next-largest North Carolina city, Raleigh. What type of chart is it?
- A column, or bar, chart (Correct)
- A scatter chart
- A pie chart
- A line chart
Correct: The chart is a column chart. A column chart is effective at demonstrating the differences between several items in a specific range of values.
8. 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 (Correct)
Correct: This is a line chart. Line charts are effective for illustrating trends and patterns, such as how the population changes over time.
9. In row 1 of the following spreadsheet, the words rank, name, population, and county are called what?
| A | B | C | D | |
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
- Criteria
- Descriptors
- Characteristics
- Attributes (Correct)
The column labels in row 1 are attributes that describe the data in each column. An attribute is a characteristic or quality of the data, used to label and define a column in a table.
10. Fill in the blank: In row 8 of the following spreadsheet, you can find the _____ of Cary.
| A | B | C | D | |
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
- attribute
- format
- criteria
- observation (CORRECT)
Correct: The column labels in row 1 are attributes that refer to the data in the column. An attribute is a characteristic or quality of data used to label a column in a table.
11. To find the average population of the cities in this spreadsheet, what is the correct AVERAGE function syntax?
| A | B | C | D | |
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
- AVERAGE(C2:C11)
- =AVERAGE(C2:C11) (CORRECT)
- AVERAGE(C2-C11)
- =AVERAGE(C2-C11)
Correct: The column labels in row 1 are attributes that refer to the data in the column. An attribute is a characteristic or quality of data used to label a column in a table.
12. 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 35.
You write the SQL query below. Add a WHERE clause that will return only data about the customer with ID number 35.
After you run your query, use the slider to view all the data presented.
What is the billing country for the customer with ID number 35?
- Ireland
- Argentina
- Portugal (CORRECT)
- India
The clause WHERE customer_id = 35 filters the Information to return only information about the customer with ID number 35. the over question take * from account where customer_id = 35 retrieves complete columns from the account board for that particular Customer. The WHERE clause filters the results based on the specified condition which includes the column name an equals sign and the value to match. inch this suit the charge state for the Customer with id list 35 is portugal
13. A data analyst creates the following visualization to clearly demonstrate how much more populous Charlotte is than the next-largest North Carolina city, Raleigh. It’s called a line chart
- True
- False (CORRECT)
Correct: This is a column chart. A column chart is effective at demonstrating the differences between several items in a specific range of values.
14. The column attributes for rank, name, population, and county are located in which row of the following spreadsheet?
| A | B | C | D | |
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
- 10
- 1 (CORRECT)
- 2
- 11
Correct: The column attributes for rank, name, population, and county are located in row 1. An attribute is a characteristic or quality of data used to label a column in a table.
15. In the following spreadsheet, the observation of Greensboro describes all of the data in row 4.
| A | B | C | D | |
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
- True (CORRECT)
- False
Correct: The observation of Greensboro describes all of the data in row 4. An observation is all of the attributes for something contained in a row of a data table.
16. Fill in the blank: In the following spreadsheet, the _____ feature was used to alphabetize the city names in column B
| A | B | C | D | |
| 1 | Rank | Name | Population | County |
| 2 | 7 | Cary | 170,282 | Wake, Chatham |
| 3 | 1 | Charlotte | 885,708 | Mecklenburg |
| 4 | 10 | Concord | 96,341 | Cabarrus |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 6 | Fayetteville | 211,657 | Cumberland |
| 7 | 3 | Greensboro | 296,710 | Guilford |
| 8 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 9 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 10 | 8 | Wilmington | 123,784 | New Hanover |
| 11 | 5 | Winston-Salem | 247,945 | Forsyth |
- organize range
- randomize range
- sort range (CORRECT)
- name range
The Sort range function was used to alphabetize the city names in column B. Sorting a range of data from A to Z helps data analysts organize and locate information more efficiently.
17. Fill in the blank: A data analyst creates a table, but they realize this isn’t the best visualization for their data. To fix the problem, they decide to use the _____ feature to change it to a column chart.
- image
- filter view
- rename
- chart editor (CORRECT)
Correct: The chart editor enables data analysts to choose the type of chart you’re making and customize its appearance.
18. If a data analyst wants to list the cities in this spreadsheet alphabetically, instead of numerically, what feature can they use in column B?
| A | B | C | D | |
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
- Name range
- Randomize range
- Organize range
- Sort range (CORRECT)
Correct: Sort range would be used to alphabetize the city names in column B. Sorting a range of data from A to Z helps data analysts organize and locate information more quickly.
19. A data analyst types =POPULATION(C2:C11) to find the average population of the cities in this spreadsheet. However, they realize they used the wrong formula. What syntax will correct this function?
| A | B | C | D | |
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
- AVERAGE(C2:C11)
- =AVERAGE(C2:C11) (CORRECT)
- AVERAGE(C2-C11)
- =AVERAGE(C2-C11)
Correct: The correct AVERAGE function syntax is =AVERAGE(C2:C11). AVERAGE returns an average of values from a selected range. C2:C11 is the specified range.
20. A data analyst wants 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 (CORRECT)
- Bar chart
21. A data analyst wants to demonstrate a trend of how something has changed over time. What type of chart is best for this task?
- Bar
- Line (CORRECT)
- Column
- Area
Correct: Line charts are effective for illustrating trends and patterns, such as how something changes over time.
22. Fill in the blank: A data analyst creates a table, but they realize this isn’t the best visualization for their data. To fix the problem, they decide to use the ____ feature to change it to a column chart.
- rename
- chart editor (CORRECT)
- filter view
- image
Correct!
23. 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.
- column
- line (CORRECT)
- bar
- area
Correct!
24. 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.
- column
- area
- line (CORRECT)
- bar
Correct!
25. 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.
1 SELECT
2 *
What is the job title of Andrew Adams?
- IT Manager
- General Manager (CORRECT)
- Sales Support Agent
- Sales Manager
Correct!
26.Fill in the blank: In the following spreadsheet, the feature sort range can be used to ________ the city names in column B?
| A | B | C | D | |
| 1 | Rank | Name | Population | County |
| 2 | 7 | Cary | 170,282 | Wake, Chatham |
| 3 | 1 | Charlotte | 885,708 | Mecklenburg |
| 4 | 10 | Concord | 96,341 | Cabarrus |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 6 | Fayetteville | 211,657 | Cumberland |
| 7 | 3 | Greensboro | 296,710 | Guilford |
| 8 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 9 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 10 | 8 | Wilmington | 123,784 | New Hanover |
| 11 | 5 | Winston-Salem | 247,945 | Forsyth |
- delete
- randomize
- change
- alphabetize (CORRECT)
Correct!
27. Fill in the blank: In the following spreadsheet, the column labels in row 1, population, and county, are called ________?
| A | B | C | D | |
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
- characteristics
- descriptors
- attributes (CORRECT)
- criteria
Correct!
28. In the following spreadsheet, where can the observation of Raleigh be found?
| – | A | B | C | D |
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
- Row 2
- Row 3
- Row 4 (CORRECT)
- Row 7
Correct!
29. The function =AVG_pop(C2:C11) will calculate the average population across the cities in this spreadsheet.
| – | A | B | C | D |
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
- True
- False (CORRECT)
Correct!
30. 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 7.
1 SELECT
2 *
3 FROM
4 invoice
5
After you run your query, use the slider to view all the data presented.
What is the billing country for the customer with ID number 7?
- Brazil
- Austria
- Poland
- France ( CORRECT)
Correct!
31. Which of the following best describes a bar chart?
- It is a visualization that plots a sequence of points and connects them with them with straight lines or curves.
- It is a visualization that represents data with columns, or bars, the heights of which are proportional to the values that they represent. (CORRECT)
- It is a visualization that plots individual points in the Cartesian coordinate plane.
- It is a visualization that uses a circle which is divided into wedges sized based on numerical proportion.
Correct!
32. 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 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.
- 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. (CORRECT)
Correct!
33. 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.
1 SELECT
2 *
What is the playlist with ID number 3?
- Audiobooks
- TV Shows (CORRECT)
- Music
- Moviesy
Correct: The clause FROM playlist will retrieve the data from the playlist table. The complete query is SELECT * FROM playlist. The FROM clause specifies which database table to select data from. The playlist with ID number 3 is TV Shows.
34. 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.
1 SELECT
2 *
3 FROM
4 invoice
5 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?
- Bangalore
- Tokyo
- Madrid (CORRECT)
- Paris
Correct!
35. Fill in the blank: In the following spreadsheet, the ________ of High Point describes all of the data in row 10.
| – | A | B | C | D |
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
- format
- observation (CORRECT)
- criteria
- dataset
Correct!
36. 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.
| – | A | B | C | D |
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
- True (CORRECT)
- False
Correct!
37. The function =AVERAGE(C2:C11) can be used to do what for the following spreadsheet?
| – | A | B | C | D |
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
- Arrange the rows according to increasing population size.
- Arrange the rows according to decreasing population size.
- Find the average population of the cities (CORRECT)
- Find the city with the largest population.
Correct!
38. You are working with a database table named genre that contains data about music genres. 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 genre table.
1 SELECT
2 *What is the name of the genre with ID number 3?
- Blues
- Metal (CORRECT)
- Jazz
- Rock
Correct: The clause FROM genre will retrieve the data from the genre table. The complete query is SELECT * FROM genre. The FROM clause specifies which database table to query. The name of the genre with ID number 3 is Metal.
39. The words rank, name, population, and county in row 1 of the following spreadsheet are known as descriptors.
| – | A | B | C | E |
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
- True
- False (CORRECT)
Correct!
Set up your inbox conclusion
With the skills you’ll acquire in this course, you’ll be well-equipped to tackle any challenge as a data analyst. This includes creating impactful visualizations to guide business decisions.
Let’s dive in! Join the learning journey on Coursera and develop the expertise you need to thrive as a data analyst.