Week 3 – More spreadsheet basics

ask questions to make data-driven decisions weekly challenge 3 answers

1. Fill in the blank: In spreadsheets, data analysts begin _____ with an equal sign (=).

  • cells
  • numbers
  • formulas
  • charts

2. Fill in the blank: The labels that describe the type of data contained in each column of a spreadsheet are called _____.

  • assignments
  • attributes
  • allowances
  • aspects


3. 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


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

  • True
  • False

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

  • Observation
  • Column
  • Attribute
  • Range

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

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

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

  • Context
  • Opinion
  • Stakeholders
  • Graphs

8. 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

Shuffle Q/A 1

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

  • True
  • False

10. 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

Devendra Kumar

Project Management Apprentice at Google

Leave a Reply