Google Data Analytics

Continuous data is measured and has a limited number of values. a. True b. False

False

Which of the following values are examples of a Boolean data type? Select all that apply. a. Yes or no b. True or false c. One, two, or three d. Yes, no, or unsure

a and b

Fill in the blank: Return on investment compares the cost of an investment to the _____ of that investment. a. net profit b. purpose c. future success d. timing

a. net profit

An analyst uses =SORT to sort spreadsheet data in descending order. What do they type at the end of their sort function? a. DESCEND b. FALSE c. Z-A d. TRUE

b.

You are working with a dataset from a local community college. You sort the students alphabetically by last name. This is an example of which phase of analysis? a. Format and adjust data b. Organize data (into a dataset) c. Transform data d. Get input from others

a.

You are working with three datasets about voter turnout in your county. First, you identify relationships and patterns between the datasets. Then, you use formulas and functions to make calculations based on your data. This is an example of which phase of analysis? a. Get input from others b. Organize data (into a dataset) c. Format and adjust data d. Transform data

d.

Sharing the results of your analysis with colleagues who are very familiar with the business problem supports what practice? a. Data management b. Data-driven decision-making c. Data analytics d. Data science

Data-driven decision making

Which method of data-collection is most commonly used by scientists? a. Surveys b. Observations c. Questionnaires d. Interviews

Observations

In data analytics, reports use data that doesn't change once it's been recorded. Which of the following terms describes this type of data? a. Comprehensive b. Static c. Monitored d. Real-time

Static

A data analyst creates data visualizations and a slideshow. Which phase of the data analysis process does this describe? a. Prepare b. Process c. Share d. Act

Share

If you have a short time frame for data collection and need an answer immediately, you likely will have to use historical data. a. True b. False

True

In spreadsheets, data analysts can sort a range from the Data tab in the menu or by typing a function directly into an empty cell. a. True b. False

True

Data analysts focus on statistical significance to make sure they have enough data so that a few unusual responses don't skew results. a. True b. False

False

Data ecosystems are made up of elements that _____ with each other. This makes it possible for them to produce, manage, store, organize, analyze, and share data. a. gain insights b. interact c. unite d. problem-solve

interact

Fill in the blank: In data analytics, a _____ refers to all possible data values in a certain dataset. a. source b. sample c. population d. representation

population

The people very familiar with a business problem are called _____. They are an important part of data-driven decision-making. a. stakeholders b. customers c. competitors d. subject-matter experts

subject-matter experts

A data analyst starts a new project for the operations team at their company. They take a few hours at the beginning of the project to identify their stakeholders. The secondary stakeholders are most likely which of the following people? Select all that apply. a. The president of the company b. The data analyst c. The project manager d. The vice president of operations

b and c

The destroy stage of the data life cycle might involve which of the following actions? Select all that apply. a. Storing data for future use b. Using data-erasure software c. Shredding paper files d. Uploading data to the cloud

b and c

What tactics can a data analyst use to effectively blend gut instinct with facts? Select all that apply. a. Focus on intuition to choose which data to collect and how to analyze it. b. Apply their unique past experiences to their current work, while keeping in mind the story the data is telling. c. Use their knowledge of how their company works to better understand a business need. d. Ask how to define success for a project, but rely most heavily on their own personal perspective.

b and c

Which of the following steps are key to leading a professional online meeting? Select all that apply. a. Keeping an eye on your inbox during the meeting in case of an important email b. Sitting in a quiet area that's free of distractions c. Maintaining control of the meeting by keeping everyone else on mute. d. Making sure your technology is working properly before starting the meeting

b and d

What is an example of using a metric? Select all that apply. a. Using column headers to sort and filter data b. Using key performance indicators, such as click-through rates, to measure revenue c. Using a pie chart to visualize data d. Using annual profit targets to set and evaluate goals

b and d.

A pivot table is a data-summarization tool used in data processing. Which of the following tasks can pivot tables perform? Select all that apply. a. Clean data b. Group data c. Calculate totals from data d. Reorganize data

b, c, and d.

A business decides what kind of data it needs, how the data will be managed, and who will be responsible for it during the _____ stage of the data life cycle. a. analyze b. plan c. capture d. manage

b.

You ask volunteers at a theater production which tasks they have already completed and add that data to a spreadsheet containing all required tasks. You will use the information provided by the volunteers to figure out which tasks still need to be done. This is an example of which phase of analysis? a. Format and adjust data b. Organize data (into a dataset) c. Transform data d. Get input from others

d.

A company is receiving negative comments on social media about their products. To solve this problem, a data analyst uses each of their five analytical skills: curiosity, understanding context, having a technical mindset, data design, and data strategy. This makes it possible for the analyst to use facts to guide business strategy and figure out how to improve customer satisfaction. What is this an example of? a. Data science b. Data visualization c. Gap analysis d. Data-driven decision-making

d.

Question 6 The five whys is a technique that involves asking, "Why?" five times in order to achieve what goal? a. Put a plan into action b. Use facts to guide business strategy c. Visualize how a process should look in the future d. Identify the root cause of a problem

d.

The question, "Why was the Monday afternoon yoga class successful?" is not measurable. Which of the following questions presents a measurable way to learn about the yoga class? a. Is yoga a great way to stretch and strengthen your body? b. Why do people like taking yoga classes on Mondays? c. Do yoga instructors seem more energetic at the beginning of the week? d. How many customers responded to our half-price yoga promotion?

d.

What is the correct spreadsheet formula for multiplying cell K3 times cell K8? a. =K3xK8 b. =K3/K8 c. =K3^K8 d. =K3*K8

d.

_____ involves the ability to break things down into smaller steps or pieces and work with them in an orderly and logical way a. Context b. Curiosity c. Data strategy d. A technical mindset

d.

On a customer service questionnaire, a data analyst asks, "If you could contact our customer service department via chat, how much valuable time would that save you?" Why is this question unfair? a. It is vague b. It makes assumptions c. It is closed-ended d. It uses slang words that not everyone can understand

b.

Which spreadsheet menu function is used to sort all data in a spreadsheet by the ranking of a specific sorted column? a. Sort By Rank b. Sort Sheet c. Sort Data d. Sort Range

b.

Fill in the blank: In spreadsheets, data analysts begin _____ with an equal sign (=). a. charts b. formulas c. numbers d. cells

formulas

Seeking out new challenges and experiences in order to learn is an example of which analytical skill? a. Curiosity b. Data strategy c. Understanding context d. Having a technical mindset

Curiosity

There are four key questions data analysts ask themselves: Who is my audience? What do they already know? What do they need to know? And how can I communicate effectively with them? These questions enable data analysts to identify the person in charge of managing the data. a. True b. False

False

Which of the following statements accurately describe formulas and functions? Select all that apply. a. Formulas are instructions that perform specific calculations. b. Formulas and functions assist data analysts in calculations, both simple and complex. c. Functions are preset commands that perform calculations. d. Formulas may only be used once per spreadsheet column.

a, b, and c

Arriving at meetings prepared is an important part of creating a professional work environment. This involves which of the following actions? Select all that apply. a. Reading the meeting agenda ahead of time b. Bringing materials to take notes with c. Bringing a laptop to keep an eye on emails d. Considering what questions you may be asked so you're prepared to answer

a, b, and d

In the analyze stage of the data life cycle, what might a data analyst do? Select all that apply. a. Use a formula to perform calculations b. Create a report from the data c. Choose the format of spreadsheet headings d. Use spreadsheets to aggregate data

a, b, and d

Understanding context is an analytical skill best described by which of the following? Select all that apply. a. Working with facts in an orderly manner b. Identifying the motivation behind the collection of a dataset c. Adding descriptive headers to columns of data in a spreadsheet d. Gathering additional information about data to understand the broader picture

a, b, and d

A data analyst is researching the buying behavior of people who shop at a company's retail store and those who might shop there in the future. During the analysis, it will be important to stay in communication with the team that most often interacts with these shoppers. What is the name of this team? a. Customer-facing team b. Executive team c. Project management team d. Data science team

a.

Describe how the data life cycle differs from data analysis. a. The data life cycle deals with the stages that data goes through during its useful life; data analysis is the process of analyzing data. b. The data life cycle deals with making informed decisions; data analysis is using tools to transform data. c. The data life cycle deals with identifying the best data to solve a problem; data analysis is about asking effective questions. d. The data life cycle deals with transforming and verifying data; data analysis is using the insights gained from the data.

a.

What is the main difference between a formula and a function? a. A formula is a set of instructions used to perform a specified calculation; a function is a preset command that automatically performs a specified process. b. A formula is used to add or subtract; a function is used to multiply or divide. c. A formula can be used multiple times in a spreadsheet; a function can only be used once. d. A formula begins with an equal sign (=); a function begins with an asterisk (*).

a.

Your data analytics team has been working on a project for a few weeks. You're almost done, when your supervisor suddenly changes the business task. Everyone has to start all over again. You announce to the team that you're going to say something to the supervisor about how unreasonable this is. What's the best next step? a. Take a few minutes to calm down, then ask your colleagues to share their perspectives so you can work together to determine the best next step. b. Write a polite, but strongly worded email to your supervisor. c. Go see your supervisor face-to-face and tell them why you're so upset. d. Insist that the entire data analytics team complain to your supervisor.

a.

The primary goal of a data _____ is to find answers to existing questions by creating insights from data sources. a. designer b. engineer c. scientist d. analyst

analyst

Fill in the blank: The labels that describe the type of data contained in each column of a spreadsheet are called _____. a. aspects b. attributes c. allowances d. assignments

attributes

Which of the following options describes a metric goal? Select all that apply. a. Indefinite b. Measurable c. Based on theory d. Evaluated using metrics

b and d.

Fill in the blank: A data analyst uses _____ to decide which data is relevant to their analysis and which data types and variables are appropriate. a. database relationships b. database organization c. database references d. database normalization

b.

Organizations such as the U.S. Centers for Disease Control (CDC) often use data collected from hospitals. What kind of data is the CDC using if it is collected by hospitals, then sold to the CDC for its own analysis? a. Multiple-party data b. First-party data c. Second-party data d. Third-party data

c.

Which of the following is an example of structured data? a. Digital photo b. Audio file c. Relational database d. Video file

c.

A data analyst is working in a spreadsheet application. They use Save As to change the file type from .XLS to .CSV. This is an example of a data transformation. a. True b. False

True

A company takes insights provided by its data analytics team, validates them, and finalizes a strategy. They then implement a plan to solve the original business problem. This describes which step of the data analysis process? a. Analyze b. Process c. Act d. Share

Act

Which analytical skill involves managing the people, processes, and tools used in data analysis? a. Data strategy b. Data design c. Understanding context d. Curiosity

Data Strategy

A furniture manufacturer wants to find a more environmentally friendly way to make its products. A data analyst helps solve this problem by gathering relevant data, analyzing it, and using it to draw conclusions. The analyst then shares their analysis with subject-matter experts from the manufacturing team, who validate the findings. Finally, a plan is put into action. This scenario describes data science. a. True b. False

False

Nominal qualitative data has a set order or scale. a. True b. False

False

What method involves examining and evaluating how a process works currently in order to get it where you want it to be in the future? a. The five whys b. Data visualization c. Gap analysis d. Strategy

Gap analysis

The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making describes what? a. Data analysis b. Data analytics c. Data science d. Data life cycle

Data analysis

Internal data is more reliable because it's clean. a. True b. False

False

To determine an organization's annual budget, a data analyst might use a slideshow. a. True b. False

False

A data analyst wants to retrieve information from a database. Select the correct tool from the data analyst's toolkit. a. Spreadsheet b. Dashboard c. Query d. Visualization

Query

In the function =MAX(B5:B15), what does B5:B15 represent? a. Observation b. Column c. Range d. Attribute

Range

Categorizing things involves assigning items to categories. Identifying themes takes those categories a step further, grouping them into broader themes or classifications. a. True b. False

True

You read an interesting article in a magazine and want to share it in the discussion forum. What should you do when posting? Select all that apply. a. Check your post for typos or grammatical errors b. Include your email address for people to send questions or comments. c. Make sure the article is relevant to data analytics. d. Take credit for creating the article.

a and c

Fill in the blank: In data analytics, qualitative data _____. Select all that apply a. is subjective b. measures numerical facts c. is always time bound d. measures qualities and characteristics

a and d

Fill in the blank: A data analyst is using data to address a large-scale problem. This type of analysis would most likely require _____. Select all that apply. a. data that reflects change over time b. data represented by a limited number of metrics c. small data d. big data

a and d.

A query is used to _____ information from a database. Select all that apply. a. retrieve b. request c. update d. visualize

a, b, and c

Which of the following are ways that data analysts can add context to their data? Select all that apply. a. Use descriptive column headers b. Ask questions about the data c. Consider where the data came from d. Create reports for stakeholders

a, b, and c

Which of the following examples are vague questions? Select all that apply. a. Do you generally prefer hot or cold? b. How much time did you spend waiting in line? c. Who was the greatest of all time? d. What's the best place to purchase the things we need?

a, b, and c

A data analyst wants to organize a database to show only the 100 most recent real estate sales in Stamford, Connecticut. How can they do that? a. The data analyst should filter out sales in Stamford, Connecticut, then sort the most recent sales at the top of their list. b. The data analyst should add a filter to return only sales in Stamford, Connecticut, then sort the most recent sales at the top of their list. c. The data analyst should filter out sales in Stamford, Connecticut, then sort the least recent sales at the top of their list. d. The data analyst should add a filter to return only sales in Stamford, Connecticut, then sort the least recent sales at the top of their list.

b.

Fill in the blank: In data analytics, a process or set of rules to be followed for a specific task is _____. a. a pattern b. an algorithm c. a value d. a domain

b.

In long data, separate columns contain the values and the context for the values, respectively. What does each column contain in wide data? a. A specific constraint b. A unique data variable c. A unique format d. A specific data type

b.

Fill in the blank: By negatively influencing data collection, ____ can have a detrimental effect on analysis a. filtering b. objectivity c. partiality d. bias

bias

A data analyst feels overworked. They often stay late to finish work, and have started missing deadlines. Their supervisor emails them another project to complete, and this causes the analyst even more stress. How should they handle this situation? a. Respond immediately, letting the supervisor know the expectations at this company are unreasonable. b. Accept the new project right away and hope to not miss another deadline. c. Wait a few minutes to think it over, then respond with a meeting request to discuss this project and the general workload. d. Walk into the supervisor's office and tell them to give the project to someone else.

c.

A garden center wants to attract more customers. A data analyst in the marketing department suggests advertising in popular landscaping magazines. This is an example of what practice? a. Monitoring social media feedback b. Developing a data analytics case study c. Reaching your target audience d. Collecting customer information

c.

Making predictions is one of the six data analytics problem types. It deals with using data to inform decisions about how things may be in the future. Select the scenario that's an example of making predictions. a. A data analyst at a technology company uses data to identify a unique drop in social media engagement. b. A data analyst at a gas company uses historical data to analyze which time of year customers use the most gas. c. A data analyst at a shoe retailer uses data to inform the marketing plan for an upcoming summer sale. d. A data analyst at a school system uses data to make a connection between home sales and new student enrollment.

c.

Organizing available information and revealing gaps and opportunities are part of what process? a. Applying the SMART methodology b. Categorizing things c. Using structured thinking d. Identifying connections between two or more things

c.

Being able to identify a relationship between two or more pieces of data describes _____. a. correlation b. problem-orientation c. visualization d. detail-oriented thinking

correlation