Module 3: Spreadsheet Magic Answers (Part 2: Q16–30)

This is Part 2 of the Module 1 quiz answers for “Spreadsheet Magic” from the Google Data Analytics Professional Certificate on Coursera.

Here, we’ll walk through questions 16 to 30 with detailed explanations to support your learning.

To find answers to the remaining questions, check out the full module breakdown below:

16. Which of the following tasks might be performed using spreadsheets?

  • Maintain information about accounts ✅
  • Write a sales pitch
  • Develop communication skills
  • Land a new client

Explanation:
Spreadsheets are tools for managing structured, tabular data, not for writing pitches or developing skills.

17. Formulas are created by the user, whereas functions are preset commands in spreadsheets.

  • True ✅
  • False

Explanation:
Formulas are user-created (e.g., =A1+B1), functions are built-in (e.g., SUM()).

18. In the function =MAX(B5:B15), what does B5:B15 represent?

  • Observation
  • Column
  • Attribute
  • Range ✅

Explanation:
B5:B15 specifies a range of cells in column B, from row 5 to row 15. Ranges are collections of adjacent cells used in calculations.

19. What is the correct spreadsheet formula for multiplying cell H2 times cell H5?

  • =H2/H5
  • =H2^H5
  • =H2*H5 ✅
  • =H2xH5

Explanation:
* is the multiplication operator in spreadsheets.

20. To avoid bias when collecting data, a data analyst should keep what in mind?

  • Context ✅
  • Opinion
  • Stakeholders
  • Graphs

Explanation:
Knowing the context (source, purpose, collection method) helps ensure unbiased data.

21. A data analyst might use descriptive column headers in order to achieve what goal?

  • Add context to their data ✅
  • Protect the spreadsheet
  • Alphabetize the spreadsheet data
  • Filter the data

Explanation:
Clear headers help users understand the data without needing to read every row.

 

22. To determine an organization’s annual budget, a data analyst might use a slideshow.

  • True
  • False ✅

Explanation:
Spreadsheets, not slideshows, are used to analyze and calculate budgets.

23. Which of the following are ways that data analysts can add context to their data? Select all that apply.

  • Use descriptive column headers ✅
  • Consider where the data came from ✅
  • Create reports for stakeholders
  • Ask questions about the data ✅

Explanation:
Adding context involves understanding the data’s source, asking relevant questions, and using clear labels (e.g., descriptive column headers) to make the data meaningful and actionable.

24. In spreadsheets, formulas and functions end with an equal sign (=).

  • True
  • False ✅

Explanation:
Formulas start with =, they don’t end with it.

25. A data analyst could use spreadsheets to achieve which of the following tasks?

  • Motivate employees
  • Write reports
  • Build code for a new app
  • Predict next quarter’s sales ✅

Explanation:
Spreadsheets help with data analysis and forecasting.

26. In the function =MAX(G3:G13), what does G3:G13 represent?

  • an attribute
  • an observation
  • The range ✅
  • a table

Explanation:
It’s a range of cells that the function is applied to.

27. What is the correct spreadsheet formula for multiplying cell D5 times cell D7?

  • =D5xD7
  • =D5^D7
  • =D5*D7 ✅
  • =D5/D7

Explanation:
Use * for multiplication in spreadsheet formulas.

28. Fill in the blank: A data analyst considers which organization created, collected, or funded a dataset in order to understand its _____.

  • structure
  • detail
  • length
  • context ✅

Explanation:
Understanding the source helps determine bias, accuracy, and intent.

29. Which of the following statements accurately describe formulas and functions? Select all that apply.

  • Formulas are instructions that perform specific calculations. ✅
  • Formulas may only be used once per spreadsheet column.
  • Functions are preset commands that perform calculations. ✅
  • Formulas and functions assist data analysts in calculations, both simple and complex. ✅

Explanation:
Formulas = custom; Functions = predefined. Both are essential tools in analysis.

30. In the function =MAX(B5:B15), what does B5:B15 represent?

  • Attribute
  • Column
  • Observation
  • Range ✅

Explanation:
Identifies which cells to analyze.

Hope this helped! Use the buttons below to move to the previous or next part.

Part 1 (Q1–15)Part 3 (Q31–40)

Leave a Reply