Table of Content
- 1 Google Data Analytics: Course 1: Module 3 Answers
- 1.1 In this spreadsheet, what type of tree is in cell C2?
- 1.2 In the following query, what will be retrieved from the database?
- 1.3 Which of the following statements accurately describe spreadsheet attributes and observations? Select all that apply.
- 1.4 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?
- 1.5 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?
- 1.6 Fill in the blank: The SQL clause SELECT * is used to _____ all data from a particular table.
- 1.7 In the following query, which clause indicates the table from which to retrieve data?
- 1.8 Which text wrapping feature sets spreadsheet cells to automatically change their height to allow the text in the cell to fit?
- 1.9 Which of the following statements accurately describe data visualizations and visualization tools? Select all that apply.
- 1.10 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?
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.
- 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