Module 3 challenge: Ask Questions to Make Data-Driven Decisions (Google Data Analytics Professional Certificate) Answers 2025

Question 1

In this spreadsheet, what will be returned from =B4*E3?

✅ 90
❌ 27
❌ 33
❌ 10

Explanation:

• Cell B4 = 15

• Cell E3 = 6

• Formula → =B4*E3 → 15 × 6 = 90

Question 2

Fill in the blank: A range is a _____ of two or more cells.

✅ collection
❌ worksheet
❌ table
❌ grid

Explanation:
A range is a collection of cells (e.g., A1:A10) that are grouped together for operations.

Question 3

What are common focus areas when creating a scope of work as a data analyst?

✅ Note when the client can expect reports
✅ Include key information about data sources
✅ Establish an agreed-upon outline of the work to be performed
❌ Make sure the data is filtered and sorted

Explanation:
A scope of work (SOW) defines project deliverables, timelines, and responsibilities — not data cleaning steps.

Question 4

A data professional encounters a REF error. How should they resolve the problem?

✅ Determine whether a referenced cell, row, or column was deleted.
❌ Ensure the referenced formula name is recognized.
❌ Insert a delimiter between the cell values.
❌ Confirm that start and end dates are in order.

Explanation:
A #REF! error happens when a referenced cell is deleted or invalid, so fixing the reference resolves it.

Question 5

Which SUM function adds all values between B1 and D6?

✅ =SUM(B1:D6)
❌ =SUM(B1,D6)
❌ =SUM(B1-D6)
❌ =SUM,B1+D6

Explanation:
In Excel/Sheets syntax, the colon (:) defines a continuous range, so =SUM(B1:D6) adds all cells in that rectangle.

Question 6

Which statements describe structured thinking and the problem domain?

✅ Understanding the problem domain makes it possible to know the specific area of analysis required.
✅ Structured thinking involves recognizing the current problem, organizing information, revealing gaps, and identifying options.
✅ The starting place for structured thinking is the problem domain.
❌ The problem domain involves establishing checkpoints for stakeholders.

Explanation:
Structured thinking = logical, organized approach to analysis.
Problem domain = context or area of the issue being solved.

Question 7

What should be done to correct the DIV error in D2?

✅ Ensure the formula is not trying to divide by zero or an empty cell.
❌ Copy formula
❌ Insert comma
❌ Search for correct value

Explanation:
#DIV/0! occurs when dividing by 0 or blank → fix by checking denominator cell.

Question 8

Formula for dividing H7 by H4:

✅ =H7/H4
❌ H7:H4
❌ =H7/4
❌ H7,H4=

Explanation:
All Excel or Sheets formulas start with =; / is the division operator → =H7/H4.

🧾 Summary Table