Module 3 challenge :Foundations: Data, Data, Everywhere (Google Data Analytics Professional Certificate) Answers 2025

Question 1

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

✅ White oak
❌ Palm
❌ Maple
❌ Sycamore

Explanation:
Cell C2 refers to column C, row 2, which contains “White oak” from the table provided.

Question 2

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

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

Explanation:
SELECT * retrieves all columns, and WHERE grade = 'kindergarten' filters only kindergarten students from the riverside_elementary table.

Question 3

Which of the following statements accurately describe spreadsheet attributes and observations?

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

Explanation:

• Attributes = column headers (variables).

• Observations = rows (each record containing attribute values).

Question 4

What type of data visualization should they create to show enrollment counts by course?

✅ Bar chart
❌ Donut chart
❌ Pie chart
❌ Line chart

Explanation:
A bar chart best represents comparisons among multiple categories (38 courses) — clearer than a cluttered pie chart.

Question 5

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

✅ =C8+D8
❌ =C8,D8
❌ C8,D8
❌ C8+D8=

Explanation:
Formulas in spreadsheets always start with =. Here, =C8+D8 adds values from the two cells.

Question 6

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

✅ all data
❌ all duplicate data
❌ the data in certain rows
❌ the data in certain columns

Explanation:
SELECT * means select everything — all columns and all rows, unless filtered by a WHERE clause.

Question 7

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

✅ FROM Fiction
❌ = ‘Kingsolver’
❌ WHERE author
❌ SELECT *

Explanation:
FROM Fiction specifies the table name — Fiction — that the query will pull data from.

Question 8

Which text wrapping feature cuts off the contents of a spreadsheet cell so only the text that fits is visible?

✅ Clip
❌ Fill
❌ Overflow
❌ Wrap

Explanation:
The Clip option hides any text that doesn’t fit in the cell, unlike “Wrap” which adjusts the row height.

Question 9

Which of the following statements accurately describe data visualizations and visualization tools?

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

Explanation:
R integrates deeply with visualization libraries like ggplot2 — the statement saying it doesn’t is incorrect.

Question 10

A junior data analyst has organized column A alphabetically from A to Z. What spreadsheet feature are they using?

✅ Sort range
❌ Chart editor
❌ Dragging
❌ Formatting

Explanation:
Sort range arranges data alphabetically or numerically in ascending/descending order.

🧾 Summary Table