Skip to content

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

Question 1

A data analyst sorts all data by ranking in one column while keeping entire rows together.

✅ Sort sheet
❌ Sort rows
❌ Sort column
❌ Sort together

Explanation:
“Sort sheet” arranges all data rows based on one column’s values, ensuring that the rest of the row data stays aligned correctly.
(“Sort range” or “Sort sheet” both sort while keeping rows intact.)

Question 2

Fill in the blank: To filter clients who placed orders in the past week, use the _____ clause.

✅ WHERE
❌ FILTER
❌ LIMIT
❌ EXCEPT

Explanation:
The WHERE clause specifies conditions in SQL queries.
Example:

SELECT * FROM Customer WHERE order_date >= DATE_SUB(CURDATE(), INTERVAL 7 DAY);

Question 3

Combining data from multiple sources into one database for analysis is part of which phase?

✅ Transform data
❌ Organize data
❌ Format and adjust data
❌ Get input from others

Explanation:
The transform phase involves merging, cleaning, or reshaping data so it’s ready for analysis.

Question 4

Which statements describe sorting and filtering?

✅ Filtering is effective at reducing the amount of data displayed.
✅ Sorting enables data analysts to rank data based on a specific metric.
❌ Filtering enables viewing buggy data.
❌ Sorting cannot be done in spreadsheets.

Explanation:
Filtering hides non-relevant rows, while sorting arranges data in a logical order (ascending or descending).

Question 5

Query to examine only rhubarb sales:

✅

SELECT *
FROM ProduceSales
WHERE produce_type = 'rhubarb';

❌ Other options

Explanation:
The WHERE clause filters only rows matching specific criteria, here where produce_type = 'rhubarb'.

Question 6

Return pickup trucks with fewer than 10,000 miles, sorted oldest to newest:

✅

SELECT *
FROM `CarDealership`
WHERE Type = 'Pickup'
AND Mileage < 10000
ORDER BY year_produced ASC;

❌ Others

Explanation:

  • AND combines conditions

  • < 10000 filters low mileage

  • ORDER BY ... ASC sorts from oldest to newest year.

Question 7

Customer service data professional analyzing churn risk — what activities apply?

✅ Organize dataset by customer and purchase history
✅ Format data to filter for low satisfaction scores
❌ Request input from others
❌ Prepare report for stakeholders

Explanation:
During the analyze phase, analysts focus on organizing, filtering, and interpreting — not reporting yet.

Question 8

Sort G1:H60 in ascending order by the first column:

✅ =SORT(G1:H60, 1, TRUE)
❌ =SORT(G1:H60, 1, FALSE)
❌ =SORT(G1:H60, A, TRUE)
❌ =SORT(G1:H60, A, FALSE)

Explanation:
=SORT(range, column_index, TRUE)
TRUE = ascending order (A→Z / 0→9).
Here column 1 = column G.

Question 9

You sorted only one column — how to sort the entire spreadsheet correctly?

✅ The SORT function
✅ The Sort sheet option
❌ Sort by row
❌ Create filter view

Explanation:
Using Sort sheet (or =SORT() formula) keeps all rows together and correctly aligned.

Question 10

Return song title, artist name, and album title ordered alphabetically by artist name:

✅

SELECT song_title, artist_name, album_title
FROM music_db.songs
ORDER BY artist_name;

❌ Others

Explanation:
The ORDER BY clause specifies the sorting column.
Default order is ascending (A–Z) unless you specify DESC.

🧾 Summary Table

Q# ✅ Correct Answer(s) Key Concept
1 Sort sheet Sort full data rows
2 WHERE SQL filtering
3 Transform data Data preparation phase
4 1 & 3 ✅ Sorting vs filtering
5 WHERE produce_type = ‘rhubarb’ SQL condition
6 Type=’Pickup’ AND Mileage<10000 ORDER BY ASC Multiple conditions + sort
7 1 & 3 ✅ Analytical preparation
8 =SORT(G1:H60, 1, TRUE) Spreadsheet sort
9 SORT function, Sort sheet Proper sorting alignment
10 ORDER BY artist_name SQL sorting