Course 1 – Foundations: Data, Data, Everywhere Quiz Answers
Week 4: Set Up Your Toolbox
GOOGLE DATA ANALYTICS PROFESSIONAL CERTIFICATION
Complete Coursera Study Guide
Set Up Your Toolbox INTRODUCTION
In this part of the Coursera Google Data Analytics Professional Certification course, you will learn how to set up your toolbox for data analysis. You’ll explore the basics of spreadsheets and query languages, including common functions like sorting and filtering data. You’ll also dive into data visualization tools such as charts, tables, and graphs.
Finally, you’ll get hands-on experience building meaningful visualizations that can help inform business decisions. With these skills in hand, you will be well-prepared to take on any challenge that comes your way as a data analyst. So let’s get started!
Learning Objectives
- Describe spreadsheets, query languages, and data visualization tools, giving specific examples
- Demonstrate an understanding of the uses, basic features, and functions of a spreadsheet
- Explain the basic concepts involved in the use of SQL including specific examples of queries
- Identify the basic concepts involved in data visualization, giving 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 data table, a row is called an observation. An observation includes all of the attributes for what is contained in the row. An attribute is a quality or characteristic of data.
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: SELECT * tells the database to select all columns from the employee table. The criteria in the WHERE clause tells the database what data in those columns 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 will retrieve the data from the artist table. The complete query is SELECT * FROM artist. The FROM clause specifies which database table to select data from. There are two columns in the artist table.
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 will return only data about the album with ID number 277. The complete query is SELECT * FROM album WHERE album_id = 277. The WHERE clause filters results that meet certain conditions. The WHERE clause includes the name of the column, an equals sign, and the value(s) in the column to include. The name of the album with ID number 277 is 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)
Correct: A pie chart shows how a whole is broken down into parts and is an effective visualization for a class broken down by age.
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)
Correct: Data visualizations can clearly demonstrate patterns and trends, help stakeholders understand complex data more quickly, and illustrate relationships between data points.
GOOGLE DATA ANALYTICS COURSERA ANSWERS AND STUDY GUIDE
Liking our content? Then don’t forget to add us to your bookmarks so you can find us easily!
Weekly Breakdown | Google Study Guides | Back to Top
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 in row 7. An observation is all of the attributes for something contained 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.
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?
- Margaret Park
- Michael Mitchell
- Andrew Adams
- Nancy Edwards (Correct)
Correct: The clause FROM employee will retrieve the data from the employee table. The complete query is SELECT * FROM employee. The FROM clause specifies which database table to select data from. The employee Nancy Edwards has 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
Correct: A formula is a set of instructions used to perform a specified The clause WHERE customer_id = 28 will return only data about the customer with ID number 28. The complete query is SELECT * FROM invoice WHERE customer_id = 28. The WHERE clause filters results that meet certain conditions. The WHERE clause includes the name of the column, an equals sign, and the value(s) in the column to include. 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)
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.
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
Correct: The clause WHERE customer_id = 35 will return only data about the customer with ID number 35. The complete query is SELECT * FROM invoice WHERE customer_id = 35. The WHERE clause filters results that meet certain conditions. The WHERE clause includes the name of the column, an equals sign, and the value(s) in the column to include. The billing country for the customer with ID number 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
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.
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 find data 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.
Set up your inbox conclusion
With the skills you will learn in this course, you will be well-prepared to take on any challenge that comes your way as a data analyst. This includes building meaningful visualizations to inform business decisions.
So let’s get started! Join the learning experience in Coursera and build the skills you need to succeed as a data analyst.
Subscribe to our site
Get new content delivered directly to your inbox.
Quiztudy Top Courses
Popular in Coursera
- Meta Marketing Analytics Professional Certificate.
- Google Digital Marketing & E-commerce Professional Certificate.
- Google UX Design Professional Certificate.
- Meta Social Media Marketing Professional Certificate
- Google Project Management Professional Certificate
- Meta Front-End Developer Professional Certificate
Liking our content? Then, don’t forget to ad us to your BOOKMARKS so you can find us easily!
