Module 2 challenge :Analyze Data to Answer Questions (Google Data Analytics Professional Certificate) Answers 2025

Question 1

A junior data analyst uses a spreadsheet function to locate specific characters from account numbers.

✅ FIND
❌ WHERE
❌ IDENTIFY
❌ FROM

Explanation:
The FIND() function locates the position of a specific character or substring within a text string.
Example:

finds where the dash appears in a cell.

---

Question 2

Count the number of characters in cell P12.

✅ =LEN(P12)
❌ =LEN(P,12)
❌ =LEN(P:12)
❌ =LEN(P:P12)

Explanation:
LEN() counts the number of characters in a cell, including spaces.
Example:

returns how many characters are in P12.

---

Question 3

Create a drop-down list of priorities (high, medium, low).

✅ Data validation
❌ Conditional formatting
❌ Pop-up menus
❌ Find

Explanation:
Data validation allows you to create drop-down lists to restrict cell entries to specific values — ideal for priority levels.

---

Question 4

Financial data should be formatted as U.S. dollars.

✅ The “Format as currency” shortcut
❌ Format as money
❌ Format as Euros
❌ Format as dollars

Explanation:
“Format as currency” displays numeric data with the correct currency symbol (like $), commas, and decimal places.

---

Question 5

Combine lunch and dinner destination columns in SQL.

✅ CONCAT
❌ COMBINE
❌ GROUP
❌ JOIN

Explanation:
CONCAT() merges multiple text fields into one string.
Example:

---

Question 6

Change how spreadsheet cells appear when values ≥ 65.

✅ Conditional formatting
❌ Add color
❌ Data validation
❌ CONVERT

Explanation:
Conditional formatting automatically changes the appearance of cells (e.g., color, font, bold) when certain conditions are met.

---

Question 7

Adjust 6.234567890123…% to one decimal place in SQL.

✅ ROUND
❌ SHORTEN
❌ DECIMAL
❌ TRUNCATE

Explanation:
ROUND() rounds numeric values to the specified number of decimal places.
Example:

returns 6.2.

---

Question 8

Return “Tab” from the text string “Tableau.”

✅ =LEFT(H9, 3)
❌ =RIGHT(H9, 3)
❌ =LEFT(3, H9)
❌ =RIGHT(3, H9)

Explanation:
LEFT(text, num_chars) extracts characters starting from the left side.
Example:

→ returns “Tab”.

---

🧾 Summary Table

---