# Course 2 – Ask Questions to Make Data-Driven Decisions Quiz Answers

## Week 3: More Spreadsheet Basic

## GOOGLE DATA ANALYTICS PROFESSIONAL CERTIFICATION

## Complete Study Guide

## More Spreadsheet Basic introduction

In this part of the course, you will further your understanding of spreadsheets by exploring more advanced features such as pivot tables and data validation. You will also learn about** Google Data Analytics Certification **via Coursera, a platform that offers many professional certifications for analysts interested in learning more about data analytics.

After completing this module, you should have a better understanding of how to use spreadsheets effectively for data analysis and be well-prepared for the Google Data Analytics Certification exam. By mastering spreadsheet basics in addition to structured thinking skills, you will be well-equipped to tackle real-world problems with accurate and reliable solutions.

## Learning Objectives

- Discuss the data analyst’s use of spreadsheets with reference to roles and responsibilities
- Demonstrate the use of spreadsheets to complete basic tasks of the data analyst including entering and organizing data
- Demonstrate an understanding of the use of formulas in spreadsheets including a definition and specific examples
- Compare formulas and functions with reference to similarities and differences
- Describe the key ideas associated with structured thinking including the problem domain, scope of work, and context

## Test your knowledge on working with spreadsheets

### 1. When giving a spreadsheet a title, what are some best practices to follow? Select all that apply.

- Titles should state what the data in the spreadsheet is about
**(Correct)** - Titles should be short
**(Correct)** - Titles should be in ALL CAPS
- Titles should be clear
**(Correct)**

**Correct: Spreadsheet titles should be short, clear, and state exactly what the data in the spreadsheet is about.**

### 2. Fill in the blank: Data analysts can use _____ to highlight the area around cells in order to see spreadsheet data more clearly.

- filters
- italics
- pivot tables
- borders
**(Correct)**

**Correct: Data analysts use borders to highlight the area around cells in order to see spreadsheet data more clearly.**

### 3. Within a spreadsheet, data analysts use which tools to save time and effort by automating commands? Select all that apply.

- Functions
**(Correct)** - Tables
- Formulas
**(Correct)** - Filters

**Correct: Data analysts use formulas and functions to save time and effort by automating commands.**

## Test your knowledge on using formulas in spreadsheets

## 1. Which of the following are examples of operators used in formulas? Select all that apply.

- Forward slash (/)
**(Correct)** - Asterisk (*)
**(Correct)** - Hyphen (-)
**(Correct)** - Hash (#)

**Correct: The asterisk, hyphen, and forward slash are examples of operators used in formulas.**

## 2. In a spreadsheet, a formula should always start with which of the following operators?

- Dash (—)
- Colon (:)
- Equal sign (=)
**(Correct)** - Plus-minus (±)

**Correct: In a spreadsheet, a formula should always start with an equal sign.**

### 3. What is the term for the set of cells that a data analyst selects to include in a formula?

- Data boundary
- Data range
**(Correct)** - Cell set
- Cell domain

**Correct: The set of cells a data analyst selects to include in a formula is called the data range.**

### 4. In a formula, the plus sign (+) is the operator for addition, and the hyphen (-) is the operator for subtraction.

- True
**(Correct)** - False

**Correct: In a formula, the plus sign (+) is the operator for addition, and the hyphen (-) is the operator for subtraction.**

### 5. Which of the following functions quickly counts how many items in a range of cells meet a given criterion?

- The COUNTIF function
**(Correct)** - The TEXT function
- The MAX function
- The SUM function

**Correct The COUNTIF function quickly counts how many items in a range of cells meet a given criterion. Using functions to make calculations and analyze data is an important skill for a data analyst. Going forward, you will continue to develop this skill as you work with more complex datasets.**

## Test your knowledge on using functions in spreadsheets

### 1. Data analysts use which of the following functions to quickly perform calculations in a spreadsheet? Select all that apply.

- MIN
**(Correct)** - SUM
**(Correct)** - MASS
- AVERAGE
**(Correct)**

**Correct: AVERAGE, MIN, and SUM are functions used to quickly perform calculations in a spreadsheet.**

### 2. What is the term for a preset command in a spreadsheet?

- Function
**(Correct)** - Quotient
- Cell
- Range

**Correct: A preset command in a spreadsheet is called a function.**

### 3. You are working with spreadsheet data about a cross-country relay race. Each runner’s times are located in cells H2 through H28. To find the runner with the slowest time, what is the correct function?

- =MIN(H2-H28)
- =HIGH(H2-H28)
- =MAX(H2:H28)
**(Correct)** - =LOW(H2:H28)

**Correct: The function is =MAX(H2:H28). The largest numeric value corresponds to the slowest time in the race. MAX returns the largest numeric value from a range of cells. And H2:H28 is the specified range.**

### 4. When you created a complete and thorough mock SOW, which foundational pieces of content did you include? Select all that apply.

- Deliverables
**(Correct)** - Milestones
**(Correct)** - Timeline
**(Correct)** - Reports
**(Correct)** - Budget

**Correct: In your mock scope-of-work, you should have included four foundational pieces of content: the deliverables, milestones, timeline, and reports. Once these items are in place, the SOW will help keep you, your team, and your project stakeholders organized and on the same page. Going forward, you can use this industry-standard tool to clarify a project’s business goals and how to accomplish them—just like a professional data analyst!**

## Test your knowledge on Structured thinking

### 1. What are the key elements of structured thinking? Select all that apply.

- Implementing a solution
- Recognizing the current problem or situation
**(Correct)** - Organizing available information
**(Correct)** - Revealing gaps and opportunities in order to identify the options
**(Correct)**

**Correct: Structured thinking is the process of recognizing the current problem or situation, organizing available information, revealing gaps and opportunities, and identifying the options.**

**Correct: Considering inclusive sample populations, social context, and self-reported data enable fairness in data collection.**

### 2. Fill in the blank: A scope of work is an agreed-upon _____ of the work you’re going to perform on a project.

- diagram
- to-do list
- outline
**(Correct)** - report

**Correct: A scope of work is an agreed-upon outline of the work you’re going to perform on a project.**

### 3. What are some strategies to ensure your data is accurate and fair? Select all that apply.

- Make sure you start with an accurate representation of the population in the sample
**(Correct)** - Use data that is very personal to you.
- Think through the “who, what, where, when, how, and why” of your data
**(Correct)** - Collect the data in an objective way
**(Correct)**

**Correct: To ensure your data is accurate and fair, make sure you start with an accurate representation of the population in the sample; collect the data in an objective way; and ask questions about the data.**

## GOOGLE DATA ANALYTICS COURSERA ANSWERS AND STUDY GUIDE

**Liking our content? Then don’t forget to add us to your bookmarks so you can find us easily!**

Weekly Breakdown | Google Study Guides | Back to Top

## Ask Questions to Make Data-Driven Decisions Weekly Challenge 3

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

- cells
- charts
- formulas
**(Correct)** - numbers

**Correct: In spreadsheets, data analysts begin formulas with an equal sign (=).**

### 2. What do data analysts use to label the type of data contained in each column in a spreadsheet?

- Menus
- Attributes
**(Correct)** - Tables
- Headings

**Correct: To label the type of data contained in each column in a spreadsheet, data analysts use attributes.**

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

- True
- False
**(Correct)**

**Correct: To determine an organization’s annual budget, a data analyst might use a spreadsheet.**

## 4. Which of the following statements describes a key difference between formulas and functions?

- Formulas span two or more cells, and functions exist in only one cell.
- Formulas are written by the user, and functions are already defined.
**(Correct)** - Formulas are used in graphs, and functions are not.
- Formulas contain words and numbers, and functions contain numbers only.

**Correct: Formulas are written by the user, and functions are already defined.**

### 5. In the function =MAX(A1:A12), what does A1:A12 represent?

- The maximum
- The formula
- The range
**(Correct)** - The operator

**Correct: In the function, A1:A12 represents the range. A range is a collection of two or more cells.**

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

- =D5^D7
- =D5/D7
- =D5*D7
**(Correct)** - =D5xD7

**Correct: The correct spreadsheet formula for multiplying cell D5 times cell D7 is =D5*D7. The asterisk (*) is the operator for multiplication.**

### 7. Fill in the blank: By negatively influencing data collection, ____ can have a detrimental effect on analysis.

- bias
**(Correct)** - objectivity
- partiality
- filtering

**Correct: By negatively influencing data collection, bias can have a detrimental effect on analysis.**

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

- Create reports for stakeholders
- Consider where the data came from
**(Correct)** - Ask questions about the data
**(Correct)** - Use descriptive column headers
**(Correct)**

**Correct: To add context to their data, data analysts ask questions about the data, consider where it came from, and use descriptive column headers.**

### 9. Both formulas and functions in spreadsheets begin with what symbol?

- Colon (:)
- Bracket ([)
- Hyphen (-)
- Equal sign (=)
**(Correct)**

**Correct: Both formulas and functions in spreadsheets begin with an equal sign.**

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

- Predict next quarter’s sales
**(Correct)** - Motivate employees
- Build code for a new app
- Write reports

**Correct: A spreadsheet could be used to predict next quarter’s sales.**

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

- True
**(Correct)** - False

**Correct: Formulas are created by the user, whereas functions are preset commands in spreadsheets.**

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

- The range
**(Correct)** - a table
- an attribute
- an observation

**Correct: In the function =MAX(G3:G13), G3:G13 represents the range. A range is a collection of two or more cells.**

### 13. What is the correct spreadsheet formula for multiplying cell K3 times cell K8?

- =K3*K8
**(Correct)** - =K3^K8
- =K3xK8
- =K3/K8

**Correct: The correct spreadsheet formula for multiplying cell K3 times cell K8 is =K3*K8. The asterisk (*) is the operator for multiplication.**

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

- Opinion
- Context
**(Correct)** - Graphs
- Stakeholders

**Correct: To avoid bias when collecting data, a data analyst should keep context in mind.**

### 15. Attributes are used in spreadsheets for what purpose?

- Label the data in each column
**(Correct)** - Insert data into each column
- Analyze the data in a row
- Add a new column

**Correct: Attributes are used to label the type of data in each column in a spreadsheet.**

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

- Alphabetize the spreadsheet data
- Filter the data
- Add context to their data
**(Correct)** - Protect the spreadsheet

**Correct: A data analyst might use descriptive column headers in order to add context to the data.**

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

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

**Correct: Formulas are instructions that perform specific calculations. And functions are preset commands that perform calculations. Formulas and functions assist data analysts in calculations, both simple and complex.**

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

- Column
- Attribute
- Observation
- Range
**(Correct)**

**Correct: In the function =MAX(B5:B15), B5:B15 represents the range. A range is a collection of two or more cells.**

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

- =H2xH5
- =H2/H5
- =H2*H5
**(Correct)** - =H2^H5

**Correct: The correct spreadsheet formula for multiplying cells H2 times cell H5 is =H2*H5. The asterisk (*) is the operator for multiplication.**

### 20. Relational databases contain a series of tables connected to form relationships. Which two types of fields exist in two connected tables?

- Primary and foreign keys
**(CORRECT)** - Internal and external data
- Descriptive and structural metadata
- Star and snowflake schemas

Correct: Primary and foreign keys exist in two connected tables in a relational database.

### 21. Data analysts use metadata for what tasks? Select all that apply.

- To perform data analyses
- To evaluate the quality of data
**(CORRECT)** - To interpret the contents of a database
**(CORRECT)** - To combine data from more than one source
**(CORRECT)**

**Correct: Data analysts use metadata to combine data, evaluate data, and interpret a database.**

**Correct: Data analysts use metadata to combine data, evaluate data, and interpret a database.**

**Correct: Data analysts use metadata to combine data, evaluate data, and interpret a database.**

### 22. Structural metadata indicates how a piece of data is organized and whether it’s part of one or more than one data collection.

- True
**(CORRECT)** - False

**Correct: Structural metadata indicates how a piece of data is organized and whether it’s part of one, or more than one, data collection. **

### 23. What is the process that data analysts use to ensure the formal management of their company’s data assets?

- Data mapping
- Data governance
**(CORRECT)** - Data aggregation
- Data integrity

**Correct: Data governance is the process of ensuring the formal management of a company’s data assets.**

### 24. A data analyst chooses not to use external data because it represents diverse perspectives. This is an appropriate decision when working with external data.

- True
- False
**(CORRECT)**

**Correct: External data representing diverse perspectives is not an appropriate reason to choose not to use a dataset. A data analyst might choose not to use external data if the it cannot be confirmed to be reliable. **

### 25. A data analyst reviews a database of Wisconsin car sales to find the last car models sold in Milwaukee in 2019. How can they sort and filter the data to return the last five cars sold at the top of their list? Select all that apply.

- Sort by sale date in ascending order
- Sort by sale date in descending order
**(CORRECT)** - Filter out sales outside of Milwaukee
**(CORRECT)** - Filter out sales not in 2019
**(CORRECT)**

**Correct: The analyst can filter out sales outside of Milwaukee in 2019 and sort by date in descending order. **

**Correct: The analyst can filter out sales outside of Milwaukee in 2019 and sort by date in descending order. **

**Correct: The analyst can filter out sales outside of Milwaukee in 2019 and sort by date in descending order. **

### 26. When writing a query, the name of the dataset can either be inside two backticks, or not, and the query will still run properly.

- True
**(CORRECT)** - False

**Correct: When writing a query, the name of the dataset can either be inside two backticks, or not, and the query will still run properly.**

### 27. You are working with a database table that contains customer data. The first_name column lists the first name of each customer. You are only interested in customers with the first name Mark.

### You write the SQL query below. Add a WHERE clause that will return only customers named Mark.

### SELECT

### *

### FROM

### customer

### How many customers are named Mark?

- 5
- 2
**(CORRECT)** - 3
- 1

**Correct: The clause WHERE first_name = ‘Mark’ will return only customers named Mark. The complete query is SELECT * FROM customer WHERE first_name = ‘Mark’. The WHERE clause filters results that meet certain conditions. The WHERE clause includes the name of the column, an equals sign, and the value(s) in the column to include. Place quotes around text values. There are two customers named Mark.**

### 28. When working with data from an external source, what can metadata help data analysts do? Select all that apply.

- Choose which analyses to run
- Combine data from more than one source
**(CORRECT)** - Understand the contents of a database
**(CORRECT)** - Ensure data is clean and reliable
**(CORRECT)**

**Correct: Metadata helps data analysts understand the contents of a database, ensure data is clean and reliable, and understand how to combine data from more than one source. **

**Correct: Metadata helps data analysts understand the contents of a database, ensure data is clean and reliable, and understand how to combine data from more than one source. **

**Correct: Metadata helps data analysts understand the contents of a database, ensure data is clean and reliable, and understand how to combine data from more than one source. **

### 29. Think about data as driving a taxi cab. In this metaphor, which of the following are examples of metadata? Select all that apply.

- Passengers the taxi picks up
- Make and model of the taxi cab
**(CORRECT)** - License plate number
**(CORRECT)** - Company that owns the taxi
**(CORRECT)**

**Correct: The license plate number, make and model of the cab, and the company that owns the taxi represent structural metadata.**

**Correct: The license plate number, make and model of the cab, and the company that owns the taxi represent structural metadata.**

**Correct: The license plate number, make and model of the cab, and the company that owns the taxi represent structural metadata.**

### 30. What are some key benefits of using external data? Select all that apply.

- External data is free to use.
- External data is always reliable.
- External data can provide industry-level perspectives.
**(CORRECT)** - External data has broad reach.
**(CORRECT)**

**Correct: Some key benefits of using external data are that it has a broad reach and it provides industry-level perspectives.**

**Correct: Some key benefits of using external data are that it has a broad reach and it provides industry-level perspectives.**

### 31. A data analyst reviews a national database of movie theater showings. They want to find the first movies shown in San Francisco in 2001. How can they organize the data to return the first 10 movies shown at the top of their list? Select all that apply.

- Sort by date in descending order
- Sort by date in ascending order
**(CORRECT)** - Filter out showings outside of San Francisco
**(CORRECT)** - Filter out showings not in 2001
**(CORRECT)**

**Correct: The analyst can filter out showings outside of San Francisco in 2001 and sort by date in ascending order. **

### 32. You are working with a database table that contains customer data. The city column lists the city where each customer is located. You want to find out which customers are located in Berlin.

### You write the SQL query below. Add a WHERE clause that will return only customers located in Berlin.

### SELECT

### *

### FROM

### customer

### How many customers are located in Berlin?

- 9
- 12
- 2
**(CORRECT)** - 7

### 33. Primary and foreign keys are two connected identifiers within separate tables. These tables exist in what kind of database?

- Primary
- Metadata
- Normalized
- Relational
**(CORRECT)**

**Correct: Primary and foreign keys are two connected identifiers within separate tables in a relational database.**

### 34. Fill in the blank: Data governance is the process of ensuring that a company’s _____ are managed in a formal manner.

- data assets
**(CORRECT)** - business tasks
- business strategies
- data engineers

**Correct: Data governance is the process of ensuring that a company’s data assets are managed in a formal manner.**

### 35. A nonprofit maintains a list of how many laptops they provide to each school in the county. In the table, there is a column called number_of_laptops. A data analyst wants to determine which schools were given the fewest laptops. How should they sort the data to return these schools first?

- Sort numerically in descending order
- Sort alphabetically in ascending order
- Sort numerically in ascending order
**(CORRECT)** - Sort alphabetically in descending order

**Correct: The data analyst should sort the number_of_laptops column numerically in ascending order. **

### 36. When writing a query, you must remove the two backticks around the name of the dataset in order for the query to run properly.

- True
- False
**(CORRECT)**

**Correct: When writing a query, the name of the dataset can either be inside two backticks, or not, and the query will still run properly.**

### 37. Think about data as a student at a high school. In this metaphor, which of the following are examples of metadata? Select all that apply.

- Grades the student earns
- Classes the student is enrolled in
**(CORRECT)** - Student’s ID number
**(CORRECT)** - Student’s enrollment date
**(CORRECT)**

**Correct: The student ID number, enrollment date, and classes the student is enrolled in represent structural metadata.**

**Correct: The student ID number, enrollment date, and classes the student is enrolled in represent structural metadata.**

**Correct: The student ID number, enrollment date, and classes the student is enrolled in represent structural metadata.**

### 38. Fill in the blank: Data _____ is the process of ensuring the formal management of a company’s data assets.

- aggregation
- governance
**(CORRECT)** - mapping
- integrity

**Correct: Data governance is the process of ensuring the formal management of a company’s data assets.**

### 39. In what circumstance might a data analyst choose not to use external data in their analysis?

- The data cannot be confirmed to be reliable
**(CORRECT)** - The data is free for anyone to access
- The data represents diverse perspectives
- The data is too thorough

**Correct: A data analyst might choose not to use external data in their analysis if the data cannot be confirmed to be reliable.**

## More Spreadsheet Basic CONCLUSION

As you can see, spreadsheets are a powerful data analytics tool that can be used to support structured thinking and help analysts better understand problems. If you want to learn more about how data analysts use spreadsheets in their work, I encourage you to join the learning experience in **Coursera**.

In this part of the course, you will explore why structured thinking helps analysts come up with solutions and better understand problems. You will also have the opportunity to practice using spreadsheets to solve real-world problems. I hope you take advantage of this opportunity to improve your data analytics skills!

#### Subscribe to our site

Get new content delivered directly to your inbox.

## Quiztudy Top Courses

## Popular in Coursera

- Meta Marketing Analytics Professional Certificate.
- Google Digital Marketing & E-commerce Professional Certificate.
- Google UX Design Professional Certificate.
- Meta Social Media Marketing Professional Certificate
- Google Project Management Professional Certificate
- Meta Front-End Developer Professional Certificate

**Liking our content? Then, don’t forget to ad us to your BOOKMARKS so you can find us easily!**