🌍 All Study Guides📊 Dashboard📰 Blog💡 About
Google Data Analytics Professional Certificate • STUDY MODE

PRACTICE QUIZ

QUESTION 1 OF 193

Structured thinking involves which of the following processes? Select all that apply.

A
Asking SMART questions
B
Recognizing the current problem or situationCorrect Answer
C
Organizing available informationCorrect Answer
D
Revealing gaps and opportunitiesCorrect Answer
Explanation:

Structured thinking involves recognizing the current problem or situation, organizing available information, revealing gaps and opportunities, and identifying the options.

QUESTION 2 OF 193

A data analyst creates data visualizations and a slideshow. Which phase of the data analysis process does this describe?

A
ShareCorrect Answer
B
Process
C
Act
D
Prepare
Explanation:

This describes the share phase of the data analysis process.

QUESTION 3 OF 193

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
Collecting customer information
B
Developing a data analytics case study
C
Monitoring social media feedback
D
Reaching your target audienceCorrect Answer
Explanation:

This is an example of reaching your target audience. In this scenario, people who read landscaping magazines are the target audience because they’re likely to be interested in shopping at the garden center.

QUESTION 4 OF 193

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 gas company uses historical data to analyze which time of year customers use the most gas.
B
A data analyst at a school system uses data to make a connection between home sales and new student enrollment.
C
A data analyst at a shoe retailer uses data to inform the marketing plan for an upcoming summer sale.Correct Answer
D
A data analyst at a technology company uses data to identify a unique drop in social media engagement.
Explanation:

A data analyst at a shoe retailer using data to inform the marketing plan for an upcoming summer sale is an example of making predictions.

QUESTION 5 OF 193

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

A
TrueCorrect Answer
B
False
Explanation:

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

QUESTION 6 OF 193

Which of the following examples are vague questions? Select all that apply.

A
How much time did you spend waiting in line?
B
Who was the greatest of all time?Correct Answer
C
Do you generally prefer hot or cold?Correct Answer
D
What’s the best place to purchase the things we need?Correct Answer
Explanation:

A vague question usually out of context and too broad to lead to a useful response.

QUESTION 7 OF 193

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
How many customers responded to our half-price yoga promotion?Correct Answer
C
Why do people like taking yoga classes on Mondays?
D
Do yoga instructors seem more energetic at the beginning of the week?
Explanation:

The number of customers who responded to the promotion can be counted, making this question measurable.

QUESTION 8 OF 193

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 makes assumptionsCorrect Answer
B
It is closed-ended
C
It uses slang words that not everyone can understand
D
It is vague
Explanation:

A common example of an unfair question is one that makes assumptions. These are questions that assume the answer to the question being asked.

QUESTION 9 OF 193

Structured thinking involves recognizing the current problem or situation you’re facing and identifying your options.

A
TrueCorrect Answer
B
False
Explanation:

Structured thinking involves recognizing the current problem or situation you’re facing and identifying your options.

QUESTION 10 OF 193

The share phase of the data analysis process typically involves which of the following activities? Select all that apply.

A
Putting analysis into action to solve a problem
B
Creating a slideshow to present to stakeholdersCorrect Answer
C
Summarizing results using data visualizationsCorrect Answer
D
Communicating findingsCorrect Answer
Explanation:

The share phase of the data analysis process typically involves communicating findings, summarizing results using data visualizations, and creating a slideshow to present to stakeholders.

QUESTION 11 OF 193

Fill in the blank: Categorizing things involves assigning items to categories, whereas _____ takes those categories a step further, grouping them into broader classifications.

A
Finding patterns
B
Making predictions
C
Discovering connections
D
Identifying themesCorrect Answer
Explanation:

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

QUESTION 12 OF 193

The question, “How could we improve our website to simplify the returns process for our online customers?” is action-oriented.

A
TrueCorrect Answer
B
False
Explanation:

The question, “How could we improve our website to simplify the returns process for our online customers?” is action-oriented because it’s likely to result in specific answers that would lead to change.

QUESTION 13 OF 193

While creating data visualizations for a slideshow, a data analyst considers, “What would help a stakeholder understand this data better?” The analyst is in the analyze step of the data analysis process.

A
True
B
FalseCorrect Answer
Explanation:

The analyst is in the share phase of the data analysis process.

QUESTION 14 OF 193

If a cooking supply store wants to attract more customers, where can they advertise to better reach their target audience? Select all that apply.

A
In a magazine all about advertising
B
At a bus stop near a local culinary schoolCorrect Answer
C
On TV during the season finale of The Best Chef in the UniverseCorrect Answer
D
On a podcast for foodiesCorrect Answer
Explanation:

To better reach their target audience, they can advertise at a bus stop near a local culinary school, on a podcast for foodies, and on TV during the season finale of The Best Chef in the Universe. A target audience is the people you’re trying to reach. In this scenario, people who enjoy food and cooking are the store’s target audience.

QUESTION 15 OF 193

A company wants to make more informed decisions regarding next year’s business strategy. An analyst uses data to help identify how things will likely work out in the future. This is an example of which problem type?

A
Discovering connections
B
Making predictionsCorrect Answer
C
Spotting something unusual
D
Identifying themes
Explanation:

This is an example of making predictions. Making predictions deals with making informed decisions about how things may be in the future.

QUESTION 16 OF 193

Describe the key difference between the problem types of categorizing things and identifying themes.

A
Categorizing things involves determining how items are different from each other. Identifying themes brings different items back together in a single group.
B
Categorizing things involves taking inventory of items. Identifying themes deals with creating labels for items.
C
Categorizing things involves assigning items to categories. Identifying themes takes those categories a step further, grouping them into broader themes.Correct Answer
D
Categorizing things involves assigning grades to items. Identifying themes involves creating new classifications for items.
Explanation:

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

QUESTION 17 OF 193

Which of the following examples are closed-ended questions? Select all that apply.

A
What are your thoughts about math?
B
How old are you?Correct Answer
C
Is math your favorite subject?Correct Answer
D
What grade did you get on the math test?Correct Answer
Explanation:

Closed-ended questions don’t encourage people to elaborate and share valuable details.

QUESTION 18 OF 193

The question, “Why don’t our employees complete their timesheets each Friday by noon?” is not action-oriented. Which of the following questions are action-oriented and more likely to lead to change? Select all that apply.

A
Why don’t employees prioritize filling out their timesheets by noon on Fridays?
B
What functionalities would make our timesheet web page more user-friendly?Correct Answer
C
How could we simplify the time-keeping process for our employees?Correct Answer
D
What features could we add to our calendar app as a weekly timesheet reminder to employees?Correct Answer
Explanation:

These questions are action-oriented. That means they’re more likely to result in specific answers that can be acted on to lead to change.

QUESTION 19 OF 193

Questions that make assumptions often involve concepts that are formed without evidence. An example of this is an idea that is accepted as true without proof.

A
TrueCorrect Answer
B
False
Explanation:

Questions that make assumptions often involve concepts that are formed without evidence. For example, an idea that is accepted as true without proof.

QUESTION 20 OF 193

A data analyst is working for a local power company. Recently, many new apartments have been built in the community, so the company wants to determine how much electricity it needs to produce for the new residents in the future. A data analyst uses data to help the company make a more informed forecast. This is an example of which problem type?

A
Discovering connections
B
Identifying themes
C
Spotting something unusual
D
Making predictionsCorrect Answer
Explanation:

This is an example of making predictions. Making predictions deals with making informed decisions about how things may be in the future.

QUESTION 21 OF 193

Which of the following questions make assumptions? Select all that apply.

A
Did you get through to customer service?
B
It must be frustrating waiting on hold for so long, right?Correct Answer
C
Keeping employees engaged is important, isn’t it?Correct Answer
D
Wouldn’t you agree that product A is better than product B?Correct Answer
Explanation:

A common example of an unfair question is one that makes assumptions. Unfair questions assume the respondent’s answer to the question.

QUESTION 22 OF 193

A recycling center that sponsors a podcast about saving the environment is an example of what strategy?

A
Staying on budget
B
Trying to reach a target audienceCorrect Answer
C
Making recommendations
D
Defining the problem to be solved
Explanation:

A recycling center sponsoring a podcast about saving the environment is an example of reaching a target audience. In this scenario, people who care about the environment are likely to be interested in recycling.

QUESTION 23 OF 193

Fill in the blank: When solving the _____ problem type, a data analytics team at a health care provider analyzes patient data from the past five years. They then use this information to understand what led to certain symptoms and what is likely to cause them again.

A
discovering connections
B
identifying themes
C
finding patternsCorrect Answer
D
categorizing things
QUESTION 24 OF 193

Which of the following statements correctly describe the SMART methodology? Select all that apply.

A
Specific questions are highly technical and detailed.
B
SMART stands for specific, measurable, action-oriented, relevant, and time-bound.Correct Answer
C
Time-bound questions specify the time to be studied.Correct Answer
D
Measurable questions can be quantified and assessed.Correct Answer
QUESTION 25 OF 193

A software company wants to develop new applications that customers will enjoy. They use an algorithm to monitor current trends and gain business intelligence about customer buying patterns. Which data problem type does this scenario describe?

A
Categorizing things
B
Spotting something unusual
C
Discovering connections
D
Making predictionsCorrect Answer
QUESTION 26 OF 193

For what reasons would it be unfair for a human resources manager to ask employees, “Why do you love working for our company?” Select all that apply.

A
It is vague
B
It is a closed-ended question
C
It is a leading questionCorrect Answer
D
It makes assumptionsCorrect Answer
QUESTION 27 OF 193

Fill in the blank: When solving the _____ problem type, a data analytics team notices a surprising shift in global economic conditions.

A
making predictions
B
discovering connections
C
identifying themes
D
spotting something unusualCorrect Answer
QUESTION 28 OF 193

A data analytics team sorts customer data by interests. Then, they group that information into broader concepts, such as customers who are interested in travel and customers who are interested in cooking. Which data problem type does this scenario describe?

A
Making predictions
B
Finding patterns
C
Discovering connections
D
Identifying themesCorrect Answer
QUESTION 29 OF 193

Which of the following questions are open-ended? Select all that apply.

A
Is it difficult for you to speak in public?
B
On a scale of 1-10 (with 10 being highest), how interested are you in current events?Correct Answer
C
How would you describe this book?Correct Answer
D
What are the three most important life lessons you have learned?Correct Answer
QUESTION 30 OF 193

A technology company faces escalating prices for a key part of one of its software applications. Data professionals at the firm discover that many other tech companies are experiencing the same issue. They reach out to the other affected businesses to share data and brainstorm solutions to their parallel challenges. What data problem type are they solving?

A
Discovering connectionsCorrect Answer
B
Categorizing things
C
Identifying themes
D
Making predictions
QUESTION 31 OF 193

Fill in the blank: The question, “How can we create a more innovative culture by empowering our employees to take risks?” is _____ because it encourages change.

A
action-orientedCorrect Answer
B
measurable
C
specific
D
relevant
QUESTION 32 OF 193

A junior data professional working for an online retailer is asked to determine which ads are most successful with shoppers. They review click-throughs compared to the type of ads presented, then group the ads accordingly. Which data problem type does this scenario describe?

A
Finding patterns
B
Discovering connections
C
Spotting something unusual
D
Categorizing thingsCorrect Answer
QUESTION 33 OF 193

A restaurant group is choosing the locations of new restaurant openings. They use an algorithm to monitor current trends and develop business intelligence about where people most frequently dine out. Which data problem type does this scenario describe?

A
Making predictionsCorrect Answer
B
Categorizing things
C
Spotting something unusual
D
Discovering connections
QUESTION 34 OF 193

Fill in the blank: When solving the _____ problem type, a data analyst discovers an established competitor suddenly changing its marketing strategy.

A
making predictions
B
discovering connections
C
spotting something unusualCorrect Answer
D
identifying themes
QUESTION 35 OF 193

Fill in the blank: The question, “Which processes can we streamline by using technology more effectively?” is _____ because it encourages change.

A
action-orientedCorrect Answer
B
measurable
C
specific
D
relevant
QUESTION 36 OF 193

A data analyst working for a health care provider is asked to determine which clinics are most efficient and which are least efficient. They review performance data, then group the clinics accordingly. Which data problem type does this scenario describe?

A
Finding patterns
B
Discovering connections
C
Spotting something unusual
D
Categorizing thingsCorrect Answer
QUESTION 37 OF 193

Fill in the blank: When solving the _____ problem type, a junior data analyst at a home goods retailer provider analyzes sales data from the past three years. They then use this information to understand what led to slumps in customer demand and what is likely to cause them again.

A
finding patternsCorrect Answer
B
categorizing things
C
identifying themes
D
discovering connections
QUESTION 38 OF 193

A junior data analyst sorts sales data by product category. Then, they group that information into broader concepts, such as customer demographic and geographic region. Which data problem type does this scenario describe?

A
Identifying themesCorrect Answer
B
Discovering connections
C
Making predictions
D
Finding patterns
QUESTION 39 OF 193

Fill in the blank: The question, “Which aspects of our packaging can be updated in order to make our product more customer-centric?” is _____ because it encourages change.

A
relevant
B
specific
C
measurable
D
action-orientedCorrect Answer
QUESTION 40 OF 193

A transportation and logistics provider aims to devise new delivery routes. They use an algorithm to monitor current traffic patterns and develop business intelligence about the busiest roads and intersections. Which data problem type does this scenario describe?

A
Making predictionsCorrect Answer
B
Spotting something unusual
C
Discovering connections
D
Categorizing things
QUESTION 41 OF 193

Fill in the blank: When solving the _____ problem type, a data professional team at a bank analyzes financial market data from the past six months. They then use this information to understand what led to certain fluctuations and what is likely to cause them again.

A
finding patternsCorrect Answer
B
discovering connections
C
categorizing things
D
identifying themes
QUESTION 42 OF 193

In data analytics, a pattern is defined as a process or set of rules to be followed for a specific task.

A
True
B
FalseCorrect Answer
Explanation:

In data analytics, an algorithm is defined as a process or set of rules to be followed for a specific task.

QUESTION 43 OF 193

Fill in the blank: In data analytics, qualitative data _____. Select all that apply.

A
measures numerical facts
B
is always time bound
C
is subjectiveCorrect Answer
D
measures qualities and characteristicsCorrect Answer
Explanation:

In data analytics, qualitative data is subjective and measures qualities and characteristics.

QUESTION 44 OF 193

In data analytics, dashboards monitor data that is a continuous source of incoming information. Which of the following terms describes this type of data?

A
Comprehensive
B
LiveCorrect Answer
C
Filtered
D
Sorted
Explanation:

Live data is a continuous source of incoming information.

QUESTION 45 OF 193

Fill in the blank: A _____ is a data-summarization tool used to sort, reorganize, group, count, total, or average data.

A
report
B
dashboard
C
function
D
pivot tableCorrect Answer
Explanation:

A pivot table is a data summarization tool used to sort, reorganize, group, count, total, or average data.

QUESTION 46 OF 193

A metric is a specific type of data that companies use to identify a problem domain.

A
True
B
FalseCorrect Answer
Explanation:

A metric is a single, quantifiable type of data used when setting and evaluating goals.

QUESTION 47 OF 193

Fill in the blank: A _____ goal is measurable and evaluated using single, quantifiable data.

A
finite
B
benchmark
C
conceptual
D
metricCorrect Answer
Explanation:

A metric goal is measurable and evaluated using single, quantifiable data.

QUESTION 48 OF 193

Fill in the blank: Return on investment compares the cost of an investment to the _____ of that investment.

A
timing
B
purpose
C
future success
D
net profitCorrect Answer
Explanation:

Return on investment compares the cost of an investment to the net profit gained from that investment.

QUESTION 49 OF 193

Describe the main differences between big and small data.

A
Small data is specific and concerns a short time period. Big data is less specific and concerns a longer time period.Correct Answer
B
Small data is typically stored and organized in databases. Big data is typically stored and organized in spreadsheets.
C
Small data is less useful to data analysts. Big data is more useful to data analysts.
D
Small data has been cleaned and sorted. Big data has not yet been cleaned or sorted.
Explanation:

Small data is specific and concerns a short time period. Big data is less specific and concerns a longer time period.

QUESTION 50 OF 193

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
StaticCorrect Answer
C
Real-time
D
Monitored
Explanation:

Static data is data that doesn’t change once it’s been recorded.

QUESTION 51 OF 193

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 represented by a limited number of metrics
B
small data
C
data that reflects change over timeCorrect Answer
D
big dataCorrect Answer
Explanation:

A data analyst using data to address a large-scale problem would most likely require big data that reflects change over time.

QUESTION 52 OF 193

Which of the following statements describes an algorithm?

A
A process or set of rules to be followed for a specific taskCorrect Answer
B
A technique for focusing on a single topic or a few closely related ideas
C
A tool that enables data analysts to spot something unusual
D
A method for recognizing the current problem or situation and identifying the options
Explanation:

A process or set of rules to be followed for a specific task describes an algorithm.

QUESTION 53 OF 193

In data analytics, quantitative data measures qualities and characteristics.

A
True
B
FalseCorrect Answer
Explanation:

In data analytics, quantitative data is specific and measures numerical facts.

QUESTION 54 OF 193

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
Calculate totals from dataCorrect Answer
C
Reorganize dataCorrect Answer
D
Group dataCorrect Answer
Explanation:

Pivot tables are used to reorganize, group, and calculate totals from data.

QUESTION 55 OF 193

A metric is a single, quantifiable type of data that can be used for what task?

A
Sorting and filtering data
B
Cleaning data
C
Defining a problem type
D
Setting and evaluating goalsCorrect Answer
Explanation:

A metric is a single, quantifiable type of data used when setting and evaluating goals.

QUESTION 56 OF 193

Fill in the blank: In data analytics, a process or set of rules to be followed for a specific task is _____.

A
an algorithmCorrect Answer
B
a pattern
C
a domain
D
a value
Explanation:

In data analytics, a process or set of rules to be followed for a specific task is an algorithm.

QUESTION 57 OF 193

In data analytics, reports use live, incoming data from multiple datasets; dashboards use static collections of data.

A
True
B
FalseCorrect Answer
Explanation:

Dashboards monitor live, incoming data from multiple datasets; reports use static collections of data.

QUESTION 58 OF 193

What is an example of using a metric? Select all that apply.

A
Using column headers to sort and filter data
B
Using a pie chart to visualize data
C
Using annual profit targets to set and evaluate goalsCorrect Answer
D
Using key performance indicators, such as click-through rates, to measure revenueCorrect Answer
Explanation:

Using key performance indicators to measure revenue and using annual profit targets to set and evaluate goals are examples of using metrics.

QUESTION 59 OF 193

If a data analyst compares the cost of an investment to the net profit of that investment over a period of time, they’re analyzing the investment scope.

A
True
B
FalseCorrect Answer
Explanation:

If a data analyst compares the cost of an investment to the net profit of that investment over a period of time, they’re analyzing the return on investment.

QUESTION 60 OF 193

Which data-summarization tool do data analysts use to sort, reorganize, group, count, total, or average data?

A
A function
B
A report
C
A dashboard
D
A pivot tableCorrect Answer
Explanation:

To sort, reorganize, group, count, total or average data, data analysts use a pivot table.

QUESTION 61 OF 193

Fill in the blank: A metric goal is a _____ goal set by a company that is evaluated using metrics.

A
finite
B
conceptual
C
theoretical
D
measurableCorrect Answer
Explanation:

A metric goal is a measurable goal set by a company that is evaluated using metrics.

QUESTION 62 OF 193

Fill in the blank: Return on investment compares the _____ of an investment to the net profit gained from that investment.

A
CostCorrect Answer
B
timing
C
success
D
purpose
Explanation:

Return on investment compares the cost of an investment to the net profit gained from that investment.

QUESTION 63 OF 193

Which of the following options describes a metric goal? Select all that apply.

A
Indefinite
B
Based on theory
C
Evaluated using metricsCorrect Answer
D
MeasurableCorrect Answer
Explanation:

A metric goal is a measurable goal set by a company that is evaluated using metrics.

QUESTION 64 OF 193

A data professional at a retail store automates a process to identify their company’s best-selling products. First, a list of all products is compiled. Then, the number of times they have been sold is counted. Finally, the products are sorted, with best-sellers at the top. What does this scenario describe?

A
Creating an algorithmCorrect Answer
B
Using a formula
C
Data-inspired decision-making
D
Making a pivot table
QUESTION 65 OF 193

Which of the following statements accurately describe qualitative and quantitative data? Select all that apply.

A
The weight of a cruise ship is an example of qualitative data.
B
The texture of a wool sweater is an example of quantitative data.
C
Qualitative data describes explanatory assessments of qualities.Correct Answer
D
Quantitative data involves specific and objective measures.Correct Answer
QUESTION 66 OF 193

When working with big data, analysts consider the veracity of the data within large, complex datasets. What does this entail?

A
Assessing the amount of data included
B
Evaluating the quality and reliability of the data
C
Understanding how quickly the data can be processed
D
Identifying the different kinds of data availableCorrect Answer
QUESTION 67 OF 193

A data professional uses a spreadsheet tool to create a visualization that totals productivity data by organization, department, and employee. What tool are they using?

A
Pivot tableCorrect Answer
B
Format
C
Data validation
D
Sort
QUESTION 68 OF 193

Company decision-makers at a gas utility want to improve business performance. How could they use metrics and a metric goal to help them do so?

A
Establish a metric goal as a single data point. Then, quantify it with metrics.
B
Set a metric as the business objective. Then, quantify it using numerous data points.
C
Develop a metric. Then, evaluate it to determine whether it advances performance.
D
Create a metric goal as the business objective. Then, evaluate it using metrics.Correct Answer
QUESTION 69 OF 193

Which of the following statements correctly describe dashboards and reports? Select all that apply.

A
Reports offer ongoing access to dynamic information.
B
An HR dashboard could be used to track employee hours worked daily.Correct Answer
C
A dashboard enables stakeholders to monitor live, incoming data.Correct Answer
D
Reports are useful for data visualization.Correct Answer
QUESTION 70 OF 193

Fill in the blank: ROI is calculated by comparing the two metrics of _____, enabling a company to determine the success of the investment.

A
investment cost and profitCorrect Answer
B
value and expenses
C
sales and revenue
D
gross margin and net margin
QUESTION 71 OF 193

What are some typical challenges that may be faced by businesses that are beginning to collect and use big data? Select all that apply.

A
Cannot help large organizations spot trends
B
Less efficient decision-making time framesCorrect Answer
C
Difficulty finding important dataCorrect Answer
D
There may be gaps in big data business toolsCorrect Answer
QUESTION 72 OF 193

A data analyst at a staffing agency automates a process to schedule temporary employees. First, a list of all employees is compiled. Then, they are sorted by availability, area of expertise, and past performance ratings. Finally, employees for each open position are listed. What does this scenario describe?

A
Making a pivot table
B
Data-inspired decision-making
C
Using a formula
D
Creating an algorithmCorrect Answer
QUESTION 73 OF 193

A data team uses a spreadsheet tool to create a visualization that summarizes financial data by region, facility, and time period. What tool are they using?

A
Format
B
Sort
C
Data validation
D
Pivot tableCorrect Answer
QUESTION 74 OF 193

Company leaders at a cafeteria supplier want to improve business performance. How could they use metrics and a metric goal to help them do so?

A
Develop a metric. Then, evaluate it to determine whether it advances performance.
B
Establish a metric goal as a single data point. Then, quantify it with metrics.
C
Set a metric as the business objective. Then, quantify it using numerous data points.
D
Create a metric goal as the business objective. Then, evaluate it using metrics.Correct Answer
QUESTION 75 OF 193

A junior data analyst uses a spreadsheet tool to create a visualization that groups and counts shipping data by carrier, route, and trip length. What tool are they using?

A
Format
B
Pivot tableCorrect Answer
C
Data validation
D
Sort
QUESTION 76 OF 193

Fill in the blank: A company determines the _____ of an investment using ROI, which is calculated by comparing the two metrics of investment cost and profit.

A
expense
B
difficulty
C
urgency
D
successCorrect Answer
QUESTION 77 OF 193

Fill in the blank: A company determines the success of an investment using _____, which is calculated by comparing the two metrics of investment cost and profit.

A
reasoning on investment
B
retention of investment
C
rating of investment
D
return on investmentCorrect Answer
QUESTION 78 OF 193

What is the relationship between a metric and a metric goal?

A
A metric goal is a business objective that is evaluated using metrics.
B
A metric is a goal that is set and evaluated by a business.Correct Answer
C
A metric goal is a single data point that is quantified with metrics.
D
A metric is a business goal that is evaluated using numerous data points.
QUESTION 79 OF 193

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

A
numbers
B
charts
C
formulasCorrect Answer
D
cells
Explanation:

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

QUESTION 80 OF 193

Attributes are used in spreadsheets for what purpose?

A
Add a new column
B
Label the data in each columnCorrect Answer
C
Insert data into each column
D
Analyze the data in a row
Explanation:

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

QUESTION 81 OF 193

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

A
Motivate employees
B
Predict next quarter’s salesCorrect Answer
C
Write reports
D
Build code for a new app
Explanation:

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

QUESTION 82 OF 193

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

A
TrueCorrect Answer
B
False
Explanation:

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

QUESTION 83 OF 193

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

A
RangeCorrect Answer
B
Observation
C
Column
D
Attribute
Explanation:

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

QUESTION 84 OF 193

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

A
=K3^K8
B
=K3/K8
C
=K3*K8Correct Answer
D
=K3xK8
Explanation:

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

QUESTION 85 OF 193

Fill in the blank: Putting data into context helps data analysts eliminate _____.

A
labels
B
biasCorrect Answer
C
intolerance
D
fairness
Explanation:

Putting data into context helps data analysts eliminate bias.

QUESTION 86 OF 193

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

A
structure
B
detail
C
contextCorrect Answer
D
length
Explanation:

Defining the problem domain is part of the structured-thinking process.

QUESTION 87 OF 193

Which of the following tasks might be performed using spreadsheets?

A
Develop communication skills
B
Land a new client
C
Write a sales pitch
D
Maintain information about accountsCorrect Answer
Explanation:

A spreadsheet could be used to maintain information about accounts.

QUESTION 88 OF 193

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

A
The rangeCorrect Answer
B
a table
C
an observation
D
an attribute
Explanation:

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

QUESTION 89 OF 193

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

A
=D5*D7Correct Answer
B
=D5/D7
C
=D5xD7
D
=D5^D7
Explanation:

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

QUESTION 90 OF 193

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

A
ContextCorrect Answer
B
Stakeholders
C
Graphs
D
Opinion
Explanation:

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

QUESTION 91 OF 193

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

A
assignments
B
aspects
C
attributesCorrect Answer
D
allowances
Explanation:

The labels that describe the type of data contained in each column of a spreadsheet are called attributes.

QUESTION 92 OF 193

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

A
True
B
FalseCorrect Answer
Explanation:

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

QUESTION 93 OF 193

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

A
Formulas span two or more cells, and functions exist in only one cell.
B
Formulas are written by the user, and functions are already defined.Correct Answer
C
Formulas are used in graphs, and functions are not.
D
Formulas contain words and numbers, and functions contain numbers only.
Explanation:

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

QUESTION 94 OF 193

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

A
The rangeCorrect Answer
B
The maximum
C
The formula
D
The operator
Explanation:

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

QUESTION 95 OF 193

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

A
=H2xH5
B
=H2^H5
C
=H2/H5
D
=H2*H5Correct Answer
Explanation:

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

QUESTION 96 OF 193

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

A
Add context to their dataCorrect Answer
B
Alphabetize the spreadsheet data
C
Filter the data
D
Protect the spreadsheet
Explanation:

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

QUESTION 97 OF 193

Both formulas and functions in spreadsheets begin with what symbol?

A
Bracket ([)
B
Equal sign (=)Correct Answer
C
Hyphen (-)
D
Colon (:)
Explanation:

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

QUESTION 98 OF 193

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

A
Tables
B
AttributesCorrect Answer
C
Headings
D
Menus
Explanation:

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

QUESTION 99 OF 193

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

A
Formulas may only be used once per spreadsheet column.
B
Formulas are instructions that perform specific calculations.Correct Answer
C
Functions are preset commands that perform calculations.Correct Answer
D
Formulas and functions assist data analysts in calculations, both simple and complex.Correct Answer
Explanation:

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.

QUESTION 100 OF 193

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

A
filtering
B
partiality
C
objectivity
D
biasCorrect Answer
Explanation:

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

QUESTION 101 OF 193

In this spreadsheet, what will be returned from the formula =C4*E2? (Image S1Q23)

A
5
B
15
C
50Correct Answer
D
2
QUESTION 102 OF 193

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

A
grid
B
worksheet
C
collectionCorrect Answer
D
table
QUESTION 103 OF 193

What are some common focus areas when creating a scope of work as a data analyst? Select all that apply.

A
Make sure the data filtered and sorted
B
Include key information about data validationCorrect Answer
C
Note when the client can expect reportsCorrect Answer
D
Establish an agreed-upon outline of the work to be performedCorrect Answer
QUESTION 104 OF 193

A junior data analyst encounters a spreadsheet error. They realize that their formula is referencing a row that has been deleted, so they correct the formula. What type of error did they resolve?

A
ERROR or parsing error
B
VALUE
C
REFCorrect Answer
D
NUM
QUESTION 105 OF 193

In this spreadsheet, which SUM function will add all of the values between cells B1 and D6? (Image S1Q27)

A
=SUM(B1-D6)
B
=SUM(B1:D6)Correct Answer
C
=SUM(B1,D6)
D
=SUM,B1+D6
QUESTION 106 OF 193

Which of the following statements accurately describe structured thinking and the problem domain? Select all that apply.

A
The problem domain involves establishing checkpoints so stakeholders are aware of project status and progress.
B
The starting place for structured thinking is the problem domain.Correct Answer
C
Structured thinking involves recognizing the current problem or situation, organizing available information, revealing gaps and opportunities, and identifying options.Correct Answer
D
Understanding the problem domain makes it possible to know the specific area of analysis required.Correct Answer
QUESTION 107 OF 193

In this spreadsheet, what should be done to correct the DIV error in cell D2? (Image S1Q29)

A
Insert a comma between the cell ranges in the formula.
B
Copy the formula to the rest of the cells in column D.
C
Search for the correct value in column A
D
Ensure the formula is not trying to divide by zero or an empty cell.Correct Answer
QUESTION 108 OF 193

What is the formula for dividing the value in spreadsheet cell G10 by the value in cell G9?

A
=G10/G9Correct Answer
B
G10,G9=
C
G10:G9
D
=G10/9
QUESTION 109 OF 193

In this spreadsheet, what will be returned from the formula =A4*D3? (Image S1Q31)

A
8
B
4
C
3
D
12Correct Answer
QUESTION 110 OF 193

What is the formula for dividing the value in spreadsheet cell H7 by the value in cell H4?

A
H7,H4=
B
=H7/H4Correct Answer
C
H7:H4
D
=H7/4
QUESTION 111 OF 193

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

A
Determine whether a referenced cell, row, or column was deleted.Correct Answer
B
Confirm that referenced start and end dates are in the correct order.
C
Ensure the referenced formula name is recognized.
D
Insert a delimiter between the cell values referenced in the formula.
QUESTION 112 OF 193

In this spreadsheet, which SUM function will add all of the values between cells E1 and F6? (Image S1Q35)

A
=SUM(E1,F6)
B
=SUM(E1-F6)
C
=SUM,E1+F6
D
=SUM(E1:F6)Correct Answer
QUESTION 113 OF 193

In this spreadsheet, what should be done to correct the DIV error in cell D1? (Image S1Q36)

A
Insert a comma between the cell ranges in the formula.
B
Ensure the formula is not trying to divide by zero or an empty cell.Correct Answer
C
Copy the formula to the rest of the cells in column D.
D
Search for the correct value in column A.
QUESTION 114 OF 193

Fill in the blank: A range is a collection of _____ cells.

A
two or moreCorrect Answer
B
averaged
C
duplicate
D
numerically ordered
QUESTION 115 OF 193

What are some common focus areas when creating a scope of work as a data analyst? Select all that apply. b)Include information about analysis of quantitative and qualitative datasets (CORRECT) d)Establish an agreed-upon outline of the work to be performed (CORRECT)

A
Develop a software solution for the analysis
C
Note when the client can expect reportsCorrect Answer
QUESTION 116 OF 193

A data professional troubleshoots a spreadsheet error. After researching the error, they discover that their formula is referencing a column that has been deleted. They update the formula with the correct column name. What type of error did they resolve?

A
NUM
B
ERROR or parsing error
C
REFCorrect Answer
D
VALUE
QUESTION 117 OF 193

In this spreadsheet, which SUM function will add all of the values between cells C1 and E6? (Image S1Q40)

A
=SUM(C1-E6)
B
=SUM(C1,E6)
C
=SUM(C1:E6)Correct Answer
D
=SUM,C1+E6
QUESTION 118 OF 193

A data analytics team is working on a project to measure the success of a company’s new financial strategy. Select the person most likely to be the primary stakeholder for this project.

A
The vice president of financeCorrect Answer
B
The data analyst
C
The project manager
D
The director of analytics
Explanation:

The primary stakeholder of this project is likely to be the vice president of finance, who can use this project’s findings to create an effective strategy for the future.

QUESTION 119 OF 193

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
Executive team
B
Customer-facing teamCorrect Answer
C
Data science team
D
Project management team
Explanation:

The customer-facing team includes anyone in an organization who interacts with customers or potential customers, such as the shoppers at a company’s retail store.

QUESTION 120 OF 193

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
FalseCorrect Answer
Explanation:

These questions enable data analysts to communicate clearly with stakeholders and team members.

QUESTION 121 OF 193

Data analysts pay attention to sample size in order to achieve what goals? Select all that apply.

A
To fully understand the scope of the analytics project
B
To avoid a small sample size leading to inaccurate judgementsCorrect Answer
C
To make sure the data represents a diverse set of perspectivesCorrect Answer
D
To make sure a few unusual responses don’t skew resultsCorrect Answer
Explanation:

Data analysts pay attention to sample size in order to represent a diverse set of perspectives and avoid skewed results or inaccurate judgements.

QUESTION 122 OF 193

A data analyst receives an email from the vice president of marketing. The vice president is upset because the report they want from the analyst is late. Select the best course of action.

A
The analyst should call the vice president and ask them how important it really is to their marketing efforts.
B
The analyst should apologize for the delay and inform the vice president that the marketing managers caused the delay.
C
The analyst should send the report immediately, even if it’s not completely finished. This will make the vice president happy.
D
The analyst should respond saying they understand the vice president’s concerns, provide a status update, and let the vice president know when to expect the completed report.Correct Answer
Explanation:

The analyst should respond saying they understand the vice president’s concerns, provide a status update, and let the vice president know when to expect the completed report. This shows the vice president that their concerns are understood and provides a status update.

QUESTION 123 OF 193

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
Bringing a laptop to keep an eye on emails
B
Bringing materials to take notes withCorrect Answer
C
Considering what questions you may be asked so you’re prepared to answerCorrect Answer
D
Reading the meeting agenda ahead of timeCorrect Answer
Explanation:

Arriving at meetings prepared involves reading the agenda ahead of time, bringing materials to take notes with, and considering what questions you may be asked so you’re prepared to answer.

QUESTION 124 OF 193

A data analyst joins an online meeting on time. After reviewing the agenda, they see that their project comes at the very end. They’re extremely busy and can use this time to stay on top of their current projects. How should they proceed?

A
Tell the participants that they’re having technical trouble, then leave the meeting to continue working on other tasks.
B
Mute themselves and turn off the camera, then continue working on other tasks until their project is mentioned.
C
Politely let the presenter know they’re going to leave the meeting and rejoin toward the end.
D
Stay focused and attentive during the entire meeting. Even though some items on the agenda don’t affect their projects, they could still learn something or have something to contribute.Correct Answer
Explanation:

They should stay focused and attentive during the entire meeting. Listening and learning from others are great ways to learn about your company, its challenges, and its goals.

QUESTION 125 OF 193

A team member has asked you to take on a task, and you don’t understand the point of the project. It seems like it will be a waste of your time. The best course of action would be to politely explain your concerns and decline the project.

A
True
B
FalseCorrect Answer
Explanation:

When you don’t understand the full context of a request, ask questions about the project goal, its data story, and the big picture vision.

QUESTION 126 OF 193

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 vice president of operations
C
The project managerCorrect Answer
D
The data analystCorrect Answer
Explanation:

The secondary stakeholders are most likely the data analyst and the project manager.

QUESTION 127 OF 193

At an online marketplace, the _____ includes anyone in an organization who interacts with current or potential shoppers.

A
customer-facing teamCorrect Answer
B
project management team
C
data science team
D
executive team
Explanation:

At an online marketplace, the customer-facing team includes anyone in an organization who interacts with current or potential shoppers.

QUESTION 128 OF 193

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
FalseCorrect Answer
Explanation:

Data analysts focus on sample size to make sure they have enough data so that a few unusual responses don’t skew results.

QUESTION 129 OF 193

A data analyst has been invited to a meeting. They review the agenda and notice that their data analysis project is one of the topics that will be discussed. They plan to arrive on time and have a pen and paper to take notes. But they do not spend time considering project updates they could share or questions they may be asked. This is appropriate because they’re not the one running the meeting.

A
True
B
FalseCorrect Answer
Explanation:

Even if the data analyst isn’t running the meeting, if their project is on the agenda, it’s a good idea to prepare to share updates and answer questions. This helps keep everyone informed and ensures effective communication.

QUESTION 130 OF 193

When participating in an online meeting, it’s okay to keep your inbox open in another browser window. Participants won’t be distracted because they can’t see it, and you might receive a very important message.

A
True
B
FalseCorrect Answer
Explanation:

When participating in an online meeting, it’s important to eliminate distractions, such as checking your email. This shows respect to the other participants.

QUESTION 131 OF 193

Conflict is a natural part of working on a team. What are some ways to help shift a situation from problematic to productive? Select all that apply. a)Identify the person who caused the issue so they can take responsibility.

B
Reframe the question by asking, “How can I help?”Correct Answer
C
Take a moment to check your emotions before engaging in an argument.Correct Answer
D
Ask for a conversation to help you better understand the big picture.Correct Answer
Explanation:

To help shift a situation from problematic to productive, reframe the question, keep your emotions in check, and establish open lines of communication.

QUESTION 132 OF 193

Fill in the blank: A data analytics team is working on a project to measure the success of a company’s new financial strategy. The vice president of finance is most likely to be the _____.

A
project manager
B
analyst
C
primary stakeholderCorrect Answer
D
secondary stakeholder
Explanation:

The vice president of finance is most likely to be the primary stakeholder.

QUESTION 133 OF 193

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 people who most often interact with these shoppers. They are members of the executive team.

A
True
B
FalseCorrect Answer
Explanation:

These people are part of the customer-facing team. The customer-facing team includes anyone in an organization who interacts with customers or potential customers, such as the shoppers at a company’s retail store.

QUESTION 134 OF 193

Which of the following steps are key to leading a professional online meeting? Select all that apply. d)Sitting in a quiet area that’s free of distractions (CORRECT)

A
Keeping an eye on your inbox during the meeting in case of an important email
B
Maintaining control of the meeting by keeping everyone else on mute.
C
Making sure your technology is working properly before starting the meetingCorrect Answer
Explanation:

When leading an online meeting, acting professionally involves encouraging others to contribute, testing technology beforehand, and eliminating distractions.

QUESTION 135 OF 193

You receive an angry email from a colleague on the marketing team. The marketing colleague believes you have taken credit for their work. You do not believe this is true. Select the best course of action.

A
Forward the email to the marketing director with an equally angry note.
B
Delete the email. It’s best not to create any additional conflict.
C
Walk over to the marketing colleague’s cubicle, and tell them you strongly disagree.
D
Reply to the email, asking if they can schedule a time to talk about this in person in order to allow both of you to share your perspectives.Correct Answer
Explanation:

You should reply to the email, asking if they can schedule a time to talk about this in person in order to allow both of you to share your perspectives. When people are feeling angry or emotional, it’s best to wait until things calm down. Then, give everyone the opportunity to share their perspectives.

QUESTION 136 OF 193

To communicate clearly with stakeholders and team members, there are four key questions data analysts ask themselves. One of them is: What does my audience need to know? Identify the remaining three questions. Select all that apply.

A
Why are stakeholders and team members important?
B
What does my audience already know?Correct Answer
C
How can I communicate effectively to my audience?Correct Answer
D
Who is my audience?Correct Answer
Explanation:

The four key questions data analysts ask themselves when communicating with stakeholders are: Who is my audience? What do they already know? What do they need to know? And how can I communicate effectively with them?

QUESTION 137 OF 193

A data analyst has been invited to a meeting. They review the agenda and notice that their data analysis project is one of the topics that will be discussed. How can they prepare for an effective meeting? Select all that apply. c)Bring materials for taking notes. (CORRECT)

A
Create and share a revised agenda that includes many more details about their project.
B
Plan to arrive on time.Correct Answer
D
Think about what project updates they should share.Correct Answer
Explanation:

They can prepare for an effective meeting by arriving on time, bringing materials to take notes with, and considering what project updates to share. COURSE CHALLENGE

QUESTION 138 OF 193

Scenario 1, questions 1-13 You’ve just started a job as a data analyst at a small software company that provides data analytics and business intelligence solutions. Your supervisor asks you to kick off a project with a new client, Athena’s Story, a feminist bookstore. They have four existing locations, and the fifth shop has just opened in your community. Athena’s Story wants to produce a campaign to generate excitement for an upcoming celebration and introduce the bookstore to the community. They share some data with your team to help make the event as successful as possible. Your task is to review the assignment and the available data, then present your approach to your supervisor. Click the link below to access the email from your supervisor: Then, review the email, and the Customer Survey and Historical Sales datasets. To use the templates for the datasets, click the links below and select “Use Template.” Links to templates: Customer Survey and Historical Sales OR If you don't have a Google account, you can download the CSV files directly from the attachments below. After reading the email, you notice that the acronym WHM appears in multiple places. You look it up online, and the most common result is web host manager. That doesn’t seem right to you, as it doesn’t fit the context of a feminist bookstore. How do you proceed?

A
Call the client to ask what WHM means and inform them that using acronyms is not a professional business practice.
B
Proceed with the project assuming WHM must mean web host manager.
C
Schedule a meeting with your supervisor, the client, and another analyst on your team to figure out the meaning.
D
Send your supervisor a polite, concise email, asking them to confirm the meaning of WHM.Correct Answer
Explanation:

You should send your supervisor a polite, concise email, asking them to confirm the meaning of WHM.

QUESTION 139 OF 193

Scenario 1 continued Now that you know WHM stands for Women’s History Month, you review the Customer Survey dataset which contains both qualitative and quantitative data. To use the template for the dataset, click the link below and select “Use Template.” Link to template: Customer Survey OR If you don't have a Google account, you can download the CSV file directly from the attachment below. The data in column F (Survey Q6: What types of books would you like to see more of at Athena's Story?) is quantitative.

A
True
B
FalseCorrect Answer
Explanation:

The data in column F (Survey Q6: What types of books would you like to see more of at Athena's Story?) is qualitative.

QUESTION 140 OF 193

Scenario 1 continued Next, you review the customer feedback in column F of the Customer Survey dataset. To use the template for the dataset, click the link below and select “Use Template.” Link to template: Customer Survey OR If you don't have a Google account, you can download the CSV file directly from the attachment below. The attribute of column F is, “Survey Q6: What types of books would you like to see more of at Athena's Story?” In order to verify that children’s literature and feminist zines are among the most popular genres, you create a visualization. This will help you clearly identify which genres are most likely to sell well during the Women’s History Month campaign. Your visualization looks like this: (Image S2Q3) Fill in the blank: The visualization you create demonstrates the percentages of each book genre that make up the total number of survey responses. It’s called a _____ chart.

A
doughnut
B
bubble
C
pieCorrect Answer
D
area
Explanation:

The visualization is called a pie chart.

QUESTION 141 OF 193

Scenario 1 continued After familiarizing yourself with the project and available data, you present your approach to your supervisor. You provide a scope of work, which includes important details, a schedule, and information on how you plan to prepare and validate the data. You also share some of your initial results and the pie chart you created. In addition, you identify the problem type, or domain, for the data analysis project. You decide that the historical sales data can be used to provide insights into the types of books that will sell best during Women’s History Month this coming year. This will also enable you to determine if Athena’s Story should begin selling more children’s literature and feminist zines. Using historical data to make informed decisions about how things may be in the future is an example of discovering connections.

A
True
B
FalseCorrect Answer
Explanation:

Using historical data to make informed decisions about how things may be in the future is an example of making predictions.

QUESTION 142 OF 193

Scenario 1 continued You’ve just started a job as a data analyst at a small software company that provides data analytics and business intelligence solutions. Your supervisor asks you to kick off a project with a new client, Athena’s Story, a feminist bookstore. They have four existing locations, and the fifth shop has just opened in your community. Athena’s Story wants to produce a campaign to generate excitement for an upcoming celebration and introduce the bookstore to the community. They share some data with your team to help make the event as successful as possible. Your task is to review the assignment and the available data, then present your approach to your supervisor. Click the link below to access the email from your supervisor: Then, review the email, and the Customer Survey and Historical Sales datasets. To use the templates for the datasets, click the links below and select “Use Template.” Links to templates: Customer Survey and Historical Sales OR If you don't have a Google account, you can download the CSV files directly from the attachments below. After reading the email, you notice that the acronym WHM appears in multiple places. You look it up online, and the most common result is web host manager. That doesn’t seem right to you, as it doesn’t fit the context of a feminist bookstore. Still, you should assume it’s correct and continue with the project.

A
True
B
FalseCorrect Answer
Explanation:

Asking questions is a very important part of data analysis. The best course of action is to send your boss a polite, concise email, asking for the meaning of WHM.

QUESTION 143 OF 193

Scenario 1 continued Next, you review the customer feedback in column F of the Customer Survey dataset. To use the template for the dataset, click the link below and select “Use Template.” Link to template: Customer Survey OR If you don't have a Google account, you can download the CSV file directly from the attachment below. The attribute of column F is, “Survey Q6: What types of books would you like to see more of at Athena's Story?” In order to verify that children’s literature and feminist zines are among the most popular genres, you create a visualization. This will help you clearly identify which genres are most likely to sell well during the Women’s History Month campaign. Your visualization looks like this: (Image S2Q6) What is a pie chart effective for demonstrating?

A
Where things are located on a map
B
Percentages that make up a wholeCorrect Answer
C
Relationships between variables
D
Trends over time
Explanation:

Pie charts are effective at demonstrating the percentages of a whole, such as the percentage of customers who would be interested in purchasing books of different genres.

QUESTION 144 OF 193

Now that you’ve confirmed that children’s literature and feminist zines are among the most requested book genres, you review the Historical Sales dataset. To use the template for the dataset, click the link below and select “Use Template.” Link to template: Historical Sales If you don't have a Google account, you can download the CSV file directly from the attachment below. You’re pleased to see that the dataset contains data that’s specific to children’s literature and feminist zines. This will provide you with the information you need to make data-inspired decisions. In addition, the children’s literature and feminist zines metrics will help you organize and analyze the data about each genre in order to determine if they’re likely to be profitable. Next, you calculate the total sales over 52 weeks for feminist zines. You type =CALCULATE(E2-E53) but get an error. What is the correct syntax?

A
=CALC(E2:E53)
B
=COUNT(E2:E53)
C
=SUM(E2:E53)Correct Answer
D
=MAX(E2:E53)
Explanation:

The correct syntax is =SUM(E2:E53). The SUM function adds the values of a range of cells. E2:E53 is the specified range.

QUESTION 145 OF 193

Scenario 1 continued Next, you review the customer feedback in column F of the Customer Survey dataset. To use the template for the dataset, click the link below and select “Use Template.” Link to template: Customer Survey OR If you don't have a Google account, you can download the CSV file directly from the attachment below. The attribute of column F is, “Survey Q6: What types of books would you like to see more of at Athena's Story?” In order to verify that children’s literature and feminist zines are among the most popular genres, you create a visualization. This will help you clearly identify which genres are most likely to sell well during the Women’s History Month campaign. Your visualization looks like this: (Image S2Q8) The chart you create demonstrates the percentages of each book genre that make up the whole. It’s called an area chart.

A
True
B
FalseCorrect Answer
Explanation:

It’s called a pie chart. Pie charts are effective at demonstrating the percentages of a whole, such as the percentage of customers who would be interested in purchasing books of different genres.

QUESTION 146 OF 193

Scenario 1 continued After familiarizing yourself with the project and available data, you present your approach to your supervisor. You provide a scope of work, which includes important details, a schedule, and information on how you plan to prepare and validate the data. You also share some of your initial results and the pie chart you created. In addition, you identify the problem type, or domain, for the data analysis project. You decide that the historical sales data can be used to provide insights into the types of books that will sell best during Women’s History Month this coming year. This will also enable you to determine if Athena’s Story should begin selling more children’s literature and feminist zines. Using historical data to make informed decisions about how things may be in the future is an example of which problem domain?

A
Making predictionsCorrect Answer
B
Spotting something unusual
C
Discovering connections
D
Identifying themes
QUESTION 147 OF 193

Scenario 1 continued Now that you know WHM stands for Women’s History Month, you continue reviewing the datasets. You notice that the Customer Survey dataset contains both qualitative and quantitative data. To use the template for the dataset, click the link below and select “Use Template.” Link to template: Customer Survey OR If you don't have a Google account, you can download the CSV file directly from the attachment below. The quantitative data includes information from which columns? Select all that apply.

A
Column E (Survey Q5: What do you like most about Athena's Story?)
B
Column A (Survey Q1: Do you plan to celebrate WHM?)Correct Answer
C
Column C (Survey Q3: Do you purchase feminist books in honor of WHM, either for yourself or as a gift for someone else?)Correct Answer
D
Column D (Survey Q4: If answered "Yes" to Q3, how many books do you typically purchase during March?)Correct Answer
Explanation:

The quantitative data includes information from columns A, C, and D.

QUESTION 148 OF 193

You’ve just started a job as a data analyst at a small software company that provides data analytics and business intelligence solutions. Your supervisor asks you to kick off a project with a new client, Athena’s Story, a feminist bookstore. They have four existing locations, and the fifth shop has just opened in your community. Athena’s Story wants to produce a campaign to generate excitement for an upcoming celebration and introduce the bookstore to the community. They share some data with your team to help make the event as successful as possible. Your task is to review the assignment and the available data, then present your approach to your supervisor. Click the link below to access the email from your supervisor: Then, review the email, and the Customer Survey and Historical Sales datasets. To use the templates for the datasets, click the links below and select “Use Template.” Links to templates: Customer Survey and Historical Sales OR If you don't have a Google account, you can download the CSV files directly from the attachments below. After reading the email, you notice that the acronym WHM appears in multiple places. You look it up online, and the most common result is web host manager. That doesn’t seem right to you, as it doesn’t fit the context of a feminist bookstore. You email your supervisor to ask. When writing your email, what do you do to ensure it sounds professional? Select all that apply.

A
Write a clear subject line that gets a fast response so you can keep working: “WHM? NEED TO KNOW WHAT THAT IS RIGHT AWAY.”
B
Use a polite greeting and closing.Correct Answer
C
Read your email aloud before sending to catch any typos or grammatical errors and to ensure the communication is clear.Correct Answer
D
Respect your supervisor’s time by writing an email that’s short and to the point.Correct Answer
Explanation:

Professional emails use a polite greeting and closing, are free of typos, and are concise.

QUESTION 149 OF 193

Scenario 1 continued After familiarizing yourself with the project and available data, you present your approach to your supervisor. You provide a scope of work, which includes important details, a schedule, and information on how you plan to prepare and validate the data. You also share some of your initial results and the pie chart you created. In addition, you identify the problem type, or domain, for the data analysis project. You decide that the historical sales data can be used to provide insights into the types of books that will sell best during Women’s History Month this coming year. This will also enable you to determine if Athena’s Story should begin selling more children’s literature and feminist zines. Using historical data to make informed decisions about how things may be in the future is an example of identifying themes.

A
True
B
FalseCorrect Answer
QUESTION 150 OF 193

Scenario 1 continued Now that you know WHM stands for Women’s History Month, you continue reviewing the datasets. You notice that the Customer Survey dataset contains both qualitative and quantitative data. To use the template for the dataset, click the link below and select “Use Template.” Link to template: Customer Survey OR If you don't have a Google account, you can download the CSV file directly from the attachment below. The qualitative data includes information from which columns? Select all that apply.

A
Column D (Survey Q4: If answered "Yes" to Q3, how many books do you typically purchase during March?)
B
Column E (Survey Q5: What do you like most about Athena's Story?)Correct Answer
C
Column F (Survey Q6: What types of books would you like to see more of at Athena's Story?)Correct Answer
D
Column B (Survey Q2: If answered "Yes" to Q1, how do you plan to celebrate?)Correct Answer
Explanation:

The qualitative data includes information from columns B, E, and F.

QUESTION 151 OF 193

Scenario 2, questions 14- You’ve completed this program and are now interviewing for your first junior data analyst position. You’re hoping to be hired by an event planning company, Patel Events Plus. Access the job description below: So far, you’ve successfully completed the first round of interviews with the human resources manager and director of data and strategy. Now, the vice president of data and strategy wants to learn more about your approach to managing projects and clients. Access the email you receive from the human resources director below: You arrive Thursday at 1:45 PM for your 2 PM interview. Soon, you’re taken into the office of Mila Aronowicz, vice president of data and strategy. After welcoming you, she begins the behavioral interview. First, she hands you a copy of Patel Events Plus’s organizational chart. Access the chart below: As you’ve learned in this course, stakeholders are people who invest time, interest, and resources into the projects you’ll be working on as a data analyst. Let’s say you’re working on a project involving data and strategy. Based on what you find in the organizational chart, if you need information from the secondary stakeholders, who can you ask? Select all that apply.

A
Vice president, data and strategy
B
Chief executive officer
C
Data analytics coordinatorCorrect Answer
D
Project manager, analyticsCorrect Answer
Explanation:

If you need information from the secondary stakeholders, you can ask the project manager and the data analytics coordinator.

QUESTION 152 OF 193

Scenario 2 continued Next, the vice president wants to understand your knowledge about asking effective questions. Consider and respond to the following question. Select all that apply. Let’s say we just completed a big event for a client and wanted to find out if they were satisfied with their experience. Provide some examples of measurable questions that you could include in the customer feedback survey.

A
What did you most love about your event experience?
B
What problems did you experience with our events team?
C
How satisfied were you with our event planning service — dissatisfied, neutral, or satisfied?Correct Answer
D
On a scale from 1 to 5, with 1 being not at all likely and 5 being very likely, how likely are you to recommend Patel Events Plus?Correct Answer
Explanation:

In the SMART methodology, measurable questions can be quantified and assessed. This might : include a 1-to-5 scale or questions with ranked responses.

QUESTION 153 OF 193

Scenario 2 continued Now, the vice president presents a situation having to do with resolving challenges and meeting stakeholder expectations. Consider and respond to the following question. You’re working with a dataset that the data analytics coordinator should have cleaned, but it turns out that it wasn’t. Your supervisor thought the dataset was ready for use, but you discover nulls, redundant data, and other issues. The project is due in less than two weeks. How would you handle that situation?

A
Call a formal meeting with the data analytics team to solve the problem. Do not invite the associate data analyst, as they clearly don’t have time to help.
B
Communicate with the data analytics coordinator about the issue and offer to work together to clean the data so the project doesn’t fall behind.Correct Answer
C
Contact the data analytics coordinator and insist they clean the dataset immediately so you don’t miss your project deadline.
D
Email your supervisor to let them know the associate data analyst did not complete their assigned task.
Explanation:

This situation presents an opportunity to communicate, collaborate, and foster positive working relationships.

QUESTION 154 OF 193

Scenario 2 continued Your next interview question deals with sharing information with stakeholders. Consider and respond to the following question. Select all that apply. Let’s say you’ve designed a dashboard to give stakeholders easy, automatic access to data about an upcoming event. Describe the benefits of using a dashboard.

A
Dashboards are easy to design and understand.
B
Dashboards present pre-cleaned, historical data.
C
Dashboards offer live monitoring of incoming data.Correct Answer
D
Dashboards enable stakeholders to interact with the data.Correct Answer
Explanation:

Dashboards offer live monitoring of incoming data and enable stakeholders to interact with the data.

QUESTION 155 OF 193

Scenario 2 continued Your final behavioral interview question involves using metrics to answer business questions. Your interviewer hands you a copy of the Patel Events dataset. To use the template for the dataset, click the link below and select “Use Template.” Link to template: Patel Events Data OR If you don't have a Google account, you can download the CSV file directly from the attachment below. Then, she asks: Recently, Patel Events Plus purchased a new venue for our events. If we asked you to compare the purchase price (cost) and net profit, what would you be calculating?

A
Sales numbers
B
Metric goal
C
Occupancy rate
D
Return on investmentCorrect Answer
Explanation:

Return on investment is made up of two metrics: the net profit over a period of time and the cost of the investment. By comparing these two metrics, you can determine the profitability of the investment.

QUESTION 156 OF 193

Scenario 2, questions 6-10 You’ve completed this program and are now interviewing for your first junior data analyst position. You’re hoping to be hired by an event planning company, Patel Events Plus. Access the job description below: So far, you’ve successfully completed the first round of interviews with the human resources manager and director of data and strategy. Now, the vice president of data and strategy wants to learn more about your approach to managing projects and clients. Access the email you receive from the human resources director below: You arrive Thursday at 1:45 PM for your 2 PM interview. Soon, you’re taken into the office of Mila Aronowicz, vice president of data and strategy. After welcoming you, she begins the behavioral interview. First, she hands you a copy of Patel Events Plus’s organizational chart. Access the chart below: As you’ve learned in this course, stakeholders are people who invest time, interest, and resources into the projects you’ll be working on as a data analyst. Secondary stakeholders are also typically responsible for managing the data. Based on what you find in the organizational chart, which of the secondary stakeholders are responsible for managing the data? Select all that apply.

A
Project manager, strategy
B
Project manager, analytics
C
Junior data analystCorrect Answer
D
Data analytics coordinatorCorrect Answer
Explanation:

The secondary stakeholders responsible for managing the data are the data analytics coordinator and junior data analyst.

QUESTION 157 OF 193

Scenario 2 continued Now, the vice president presents a situation having to do with resolving challenges and meeting stakeholder expectations. Consider and respond to the following question. You’re working on a rush project, and you discover your dataset is not clean. Even though it has numerous nulls, redundant data, and other issues, the primary stakeholder insists that you move ahead and use it anyway. The project timeline is so tight that there simply isn’t enough time for cleaning. How would you handle that situation?

A
Contact the stakeholder’s boss to let them know about the issue and ask for help managing the stakeholder’s expectations
B
Communicate the situation to your supervisor and ask for advice on how to handle the situation with the stakeholder.Correct Answer
C
The stakeholder is in charge. It's best to do as they say and use the unclean dataset.
D
Clean the data as quickly as you can. It’s not perfect, but it’s better than it was before, and this way you can meet the deadline.
Explanation:

This situation presents an opportunity to communicate, collaborate, and foster positive working relationships.

QUESTION 158 OF 193

Scenario 2 continued Your final behavioral interview question involves using metrics to answer business questions. Your interviewer hands you a copy of the Patel Events dataset. To use the template for the dataset, click the link below and select “Use Template.” Link to template: Patel Events Data OR If you don't have a Google account, you can download the CSV file directly from the attachment below. Then, she asks: Recently, Patel Events Plus purchased a new venue for our events. If we asked you to calculate the return on investment of this purchase, which metrics would you use?

A
2019 events held at new venue (column D)
B
Purchase date
C
Net profit in 2019 (column F)Correct Answer
D
Purchase price (column C)Correct Answer
Explanation:

Return on investment is made up of two metrics: the net profit over a period of time and the cost of the investment. By comparing these two metrics, you can determine the profitability of the investment.

QUESTION 159 OF 193

Now, the vice president presents a situation having to do with resolving challenges and meeting stakeholder expectations. Consider and respond to the following question. Select all that apply. You’re working with a dataset that the data analytics coordinator should have cleaned, but it turns out that it wasn’t. Your supervisor thought the dataset was ready for use, but you discover nulls, redundant data, and other issues. The project is due in less than two weeks. Which of the following options would be an appropriate approach?

A
Proceed with the project using the available data. You don’t want to get the associate data analyst in trouble, and you don’t want to miss your deadline.
B
Provide your supervisor with a proposed revised timeline. Politely explain that you need some additional time to clean the data.Correct Answer
C
Email your supervisor and the data analytics coordinator to communicate about the issue. Ask if you can meet to come up with a solution.Correct Answer
D
Email the data analytics coordinator to ask if the two of you can work together to clean the data, as the project is on a tight timeline.Correct Answer
Explanation:

This situation presents an opportunity to communicate, collaborate, and foster positive working relationships.

QUESTION 160 OF 193

Scenario 2 continued Your next interview question deals with sharing information with stakeholders. Consider and respond to the following question. Let’s say you want to share information about an upcoming event with stakeholders. It’s important that they’re able to access and interact with the data in real time. Would you create a report or a dashboard?

A
Report
B
DashboardCorrect Answer
Explanation:

Dashboards offer live monitoring of incoming data and enable stakeholders to interact with the data.

QUESTION 161 OF 193

You’ve completed this program and are now interviewing for your first junior data analyst position. You’re hoping to be hired by an event planning company, Patel Events Plus. Access the job description below: So far, you’ve successfully completed the first round of interviews with the human resources manager and director of data and strategy. Now, the vice president of data and strategy wants to learn more about your approach to managing projects and clients. Access the email you receive from the human resources director below: You arrive Thursday at 1:45 PM for your 2 PM interview. Soon, you’re taken into the office of Mila Aronowicz, vice president of data and strategy. After welcoming you, she begins the behavioral interview. First, she hands you a copy of Patel Events Plus’s organizational chart. Access the chart below: As you’ve learned in this course, stakeholders are people who invest time, interest, and resources into the projects you’ll be working on as a data analyst. Let’s say you’re working on a project involving data and strategy. Based on what you find in the organizational chart, if you need information from the primary stakeholder, who can you ask?

A
Vice president, data and strategyCorrect Answer
B
Chief executive officer
C
Project manager, analytics
D
Director, strategy
Explanation:

If you need information from the primary stakeholder, you can ask the vice president of data and strategy.

QUESTION 162 OF 193

Scenario 2 continued Your next interview question deals with sharing information with stakeholders. Consider and respond to the following question. Select all that apply. Let’s say you’ve created a report to present stakeholders with information about an upcoming event. Describe the benefits of using a report.

A
Reports enable stakeholders to interact with the data.
B
Reports offer live monitoring of incoming data.
C
Reports reflect data that’s already been cleaned and sorted.Correct Answer
D
Reports provide a snapshot of high-level, historical data.Correct Answer
Explanation:

Reports provide a snapshot of high-level, historical data and reflect data that’s already been cleaned and sorted.

QUESTION 163 OF 193

A data analyst is working on a project for the marketing department. The vice-president of marketing wants to use the results of this project to inform future marketing strategies. What role is the vice-president serving in this project?

A
Secondary stakeholder
B
Client
C
Consultant
D
Primary stakeholderCorrect Answer
QUESTION 164 OF 193

To communicate clearly with stakeholders and team members, there are four key questions data analysts ask themselves. One of the questions is: Who is my audience? Identify the remaining three questions? Select all that apply.

A
What does my audience already know?Correct Answer
B
Why are stakeholders and team members important?
C
What does my audience need to know?Correct Answer
D
How can I communicate effectively to my audience?Correct Answer
QUESTION 165 OF 193

A colleague of yours has difficulty with his workload. He comes to you often for assistance and is very appreciative of your help. However, helping him has made it difficult for you to manage your own work. How should you handle this?

A
Tell your colleague that you cannot spend this much time helping them.
B
Have your manager talk to your colleague so they stop requesting your help.
C
Go to your colleague’s manager and tell them that your colleague needs training. (INCORRECT)
D
Avoid your colleague until you get fully caught up on your work.
QUESTION 166 OF 193

A data analyst is collecting a sample for their research. Unfortunately, they have a small sample size and no time to collect more data. What challenge might this present?

A
The data will represent the population.
B
Results can be skewed.Correct Answer
C
Data manipulation will be more difficult.
D
The data will be difficult to analyze.
QUESTION 167 OF 193

When leading a meeting, it is important to respect your team members’ time. What are some ways of doing this? Select all that apply.

A
Discuss work that does not impact the attendees.
B
Arrive to the meeting on timeCorrect Answer
C
Be prepared to talk about your workCorrect Answer
D
Pay attention to what others are sayingCorrect Answer
QUESTION 168 OF 193

Your manager assigns you a project task, and you don’t understand the point of the project. What questions can you ask them to determine the objective? Select all that apply.

A
What do you have to do for this task?
B
What is their end goal?Correct Answer
C
What is the story they want to tell?Correct Answer
D
What is the big picture?Correct Answer
QUESTION 169 OF 193

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. Which of the following people are most likely the secondary stakeholders? Select all that apply.

A
The vice president of marketing
B
The data analystCorrect Answer
C
The president of the company
D
The project managerCorrect Answer
QUESTION 170 OF 193

To communicate clearly with stakeholders and team members, there are four key questions data analysts ask themselves. One of the questions is: What does my audience already know? Identify the remaining three questions. Select all that apply.

A
What does my audience need to know?Correct Answer
B
Who is my audience?Correct Answer
C
Why are stakeholders and team members important?
D
How can I communicate effectively to my audience?Correct Answer
QUESTION 171 OF 193

Your manager assigns you a new project. You tell them that it should only take you a week to finish it. After beginning the project, you realize that it will actually take closer to two weeks to finish. What should you do?

A
Work as hard as possible on the project and hope that you can get it done on time.
B
Change the project so that some of the original objectives are met by week’s end.
C
Explain to your manager that the original time frame is not possible and discuss how to proceed.Correct Answer
D
Finish what can be finished by the deadline and explain that there wasn’t enough time to do the rest.
QUESTION 172 OF 193

A data analyst collects a large amount of data for their project to ensure that the data represents a diverse set of perspectives. What element of data collection does this describe?

A
Data cleaning
B
Visualization
C
Statistical significance
D
Sample sizeCorrect Answer
QUESTION 173 OF 193

When attending an online meeting, what actions can you take to respect your colleagues’ time? Select all that apply.

A
Stay focused and attentiveCorrect Answer
B
Be prepared to discuss your workCorrect Answer
C
Have participants arrive when they choose
D
Ask questions when you need clarificationCorrect Answer
QUESTION 174 OF 193

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
Go see your supervisor face-to-face and tell them why you’re so upset.
B
Insist that the entire data analytics team complain to your supervisor.
C
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.Correct Answer
D
Write a polite, but strongly worded email to your supervisor.
QUESTION 175 OF 193

You accept a new project from a high level stakeholder. After beginning the project, you find that you aren’t sure what you are supposed to do. How do you handle this?

A
Set up a meeting with the stakeholder to discuss the specific objectives they wanted.Correct Answer
B
Determine the objectives that make the most sense and work towards those.
C
Ask a member of your team what was done on the last project and do the same.
D
Perform the standard analysis and present its insights.
QUESTION 176 OF 193

A data analyst is collecting data. They decide to gather lots of data to make sure that a few unusual responses do not skew the results later in the process. What element of data collection does this describe?

A
Statistical significance
B
Data cleaning
C
Sample sizeCorrect Answer
D
Visualization
QUESTION 177 OF 193

You are leading an online meeting to discuss the new project. What should you do before starting the meeting to make it effective? Select all that apply.

A
Ensure that essential team members attendCorrect Answer
B
Have them arrive when they choose
C
Send out an agenda for the meetingCorrect Answer
D
Ensure that all necessary technology worksCorrect Answer
QUESTION 178 OF 193

Your manager assigns you a project task, and you don’t understand the point of the project. The best course of action is to politely explain your concerns and decline the project.

A
True
B
FalseCorrect Answer
QUESTION 179 OF 193

Fill in the blank: In order to build trust, data professionals focus on the expectations of _____, who are the people investing time, interest, and resources into the project.

A
administrators
B
data analysts
C
stakeholdersCorrect Answer
D
subject-matter experts
QUESTION 180 OF 193

You are invited to a meeting. You review the agenda and notice that your data analysis project is one of the topics that will be discussed. What strategies should you use to prepare? Select all that apply.

A
Distribute a revised agenda that includes more details about your project.
B
Plan to arrive on timeCorrect Answer
C
Think about what project updates you should shareCorrect Answer
D
Bring materials for taking notesCorrect Answer
QUESTION 181 OF 193

A data team prepares to share insights with stakeholders. To ensure they communicate clearly, they follow best practices. Together, they consider four questions, including: Who is our audience? Identify the remaining three questions they should ask. Select all that apply.

A
Why are stakeholders important?
B
What does my audience already know?Correct Answer
C
What does my audience need to know?Correct Answer
D
How can I communicate effectively to my audience?Correct Answer
QUESTION 182 OF 193

Recently, you have been feeling overworked. You often stay late to finish tasks and have started missing deadlines. Your supervisor gives you another project to complete, and this causes even more stress. How should you handle this situation?

A
Respond letting the supervisor know their expectations are unreasonable.
B
Accept the new project right away and work harder to hopefully not miss another deadline.
C
Walk into the supervisor’s office and politely tell them to give the project to someone else.
D
Wait a few minutes to think it over, then request a meeting to discuss the new project and your general workload.Correct Answer
QUESTION 183 OF 193

You join an online meeting on time. After reviewing the agenda, you note that your project will be discussed at the very end. You are extremely busy and can use this time to stay on top of other projects. How should you proceed?

A
Stay focused and attentive during the entire meeting. Even though some items on the agenda don’t affect your projects, you could still learn something or have something to contribute.Correct Answer
B
Mute yourself and turn off the camera, then continue working on other tasks until your project is mentioned.
C
Tell the participants that you are having technical trouble, then leave the meeting to continue working on other tasks.
D
Politely let the presenter know you’re going to leave the meeting and rejoin toward the end.
QUESTION 184 OF 193

A data analyst researches the buying behavior of people who shop at a company’s retail store. During the analysis, which team is most likely to offer helpful insight about what these shoppers like and do not like?

A
Customer-facingCorrect Answer
B
Data science
C
Executive
D
Project management
QUESTION 185 OF 193

A data analyst reframes a question. Then, they outline the problem, challenges, potential solutions, and timeframe. What goals are they trying to achieve? Select all that apply.

A
Provide reports more quickly
B
Balance speed with accuracyCorrect Answer
C
Put the data in contextCorrect Answer
D
Communicate expectationsCorrect Answer
QUESTION 186 OF 193

A data analyst works on an analysis project that was requested by the marketing department. Who are most likely to be the secondary stakeholders? Select all that apply.

A
Vice president of finance
B
Vice president of marketing
C
Data analystCorrect Answer
D
Project managerCorrect Answer
QUESTION 187 OF 193

Fill in the blank: Stakeholders _____ when contributing to a project.

A
invest time and resourcesCorrect Answer
B
present data insights
C
connect with customers
D
implement solutions
QUESTION 188 OF 193

What are some strategies to ensure you arrive at meetings prepared? Select all that apply.

A
Bring a laptop to keep an eye on emails so you don’t miss anything important
B
Read the meeting agenda ahead of timeCorrect Answer
C
Bring materials to take notes withCorrect Answer
D
Consider what questions you may be asked so you are prepared to answerCorrect Answer
QUESTION 189 OF 193

A data analyst at an electrical utility company investigates why electricity consumption has increased in a particular area. During the analysis, which team is most likely to offer helpful insight about electricity users and their particular household needs? d)Executive 28). A data analyst works on a logistics project that aims to create more efficient truck delivery routes. Who is most likely to be the primary stakeholder?

A
Customer-facingCorrect Answer
B
Project management
C
Data science
A
Lead truck driver
B
Vice president of logisticsCorrect Answer
C
Customers receiving packages
D
Data analyst
QUESTION 190 OF 193

In order to build trust, data professionals focus on the expectations of _____, who are the people investing time, interest, and resources into the project.

A
subject-matter experts
B
stakeholdersCorrect Answer
C
data analysts
D
administrators
QUESTION 191 OF 193

What are some strategies to ensure an online meeting is effective? Select all that apply.

A
Maintain control of the meeting by keeping everyone else on mute
B
Take the meeting from an area that is free of distractionsCorrect Answer
C
Distribute an agenda beforehandCorrect Answer
D
Make sure technology is working properlyCorrect Answer
QUESTION 192 OF 193

What are some strategies to ensure you respect people’s time when leading a meeting? Select all that apply.

A
Discuss work that does not affect the attendees
B
Arrive to the meeting on timeCorrect Answer
C
Pay attention to what others are sayingCorrect Answer
D
Be prepared to talk about your workCorrect Answer
QUESTION 193 OF 193

A data analyst prepares for a stakeholder presentation. To ensure they communicate clearly, they follow best practices and ask four questions, including: What does my audience need to know? Identify the remaining three questions the data analyst should ask. Select all that apply.

A
Who is my audience?
B
How can I communicate effectively to my audience?Correct Answer
C
What does my audience want to avoid?Correct Answer
D
What does my audience already know?Correct Answer

Ready to test your recall?

Structured thinking involves which of the following processes? Select all that apply.

💡Select all 3 correct answers before submitting (0 of 3 selected).
A
Asking SMART questions
B
Recognizing the current problem or situation
C
Organizing available information
D
Revealing gaps and opportunities

How confident are you in this answer?