Google Data Analytics | Course 1 | Module 3 Answers | Coursera

Google Data Analytics: Course 1: Module 3 Answers

In this spreadsheet, what type of tree is in cell C2?

• Sycamore
• White oak
• Maple
• Palm

In the following query, what will be retrieved from the database?

SELECT *
FROM Riverside Elementary

WHERE grade = ‘kindergarten’

• All kindergarteners in all elementary schools
• All students and grades at Riverside Elementary
• All grades at Riverside Elementary
• All kindergarteners at Riverside Elementary

Which of the following statements accurately describe spreadsheet attributes and observations? Select all that apply.

• Column labels are attributes.
• Attributes are also referred to as column headers.
• Observations are characteristics or qualities of data.
• An observation includes all of the attributes contained in its row.

A data professional at a social media company wants to communicate to stakeholders about which countries have the most active users. They create a data visualization that identifies 45 different countries, then shows the number of active users from each one. What type of data visualization should they create?

• Donut chart
• Pie chart
• Bar chart
• Line chart

When working in a spreadsheet, what is the correct syntax for a formula that adds the value in cell A1 to the value in cell B1?

• A1+B1=
• =A1+B1
• =A1,B1
• A1,B1

Fill in the blank: The SQL clause SELECT * is used to _____ all data from a particular table.

• retrieve
• exclude
• copy
• archive

In the following query, which clause indicates the table from which to retrieve data?

SELECT *
FROM Garden
WHERE herb = ‘basil’

• = ‘basil’
• WHERE herb
• SELECT *
• FROM Garden

Which text wrapping feature sets spreadsheet cells to automatically change their height to allow the text in the cell to fit?

• Fill
• Wrap
• Overflow
• Clip

Which of the following statements accurately describe data visualizations and visualization tools? Select all that apply.

• Tableau enables the creation of interactive dashboards for users to share.
• Spreadsheets contain built-in chart and graph features.
• Choosing the most appropriate visualization is typically driven by the amount of data and the analysis process.
• The programming language R does not integrate with data visualization tools.

A junior data analyst has organized the data in column A to be in alphabetical order from A to Z. What spreadsheet feature are they using?

• Sort range
• Chart editor
• Formatting
• Dragging