Google Digital Marketing and E-commerce Professional Certificate • STUDY MODE
WEEKLY CHALLENGE 4
QUESTION 1 OF 52
Which of the following are reasons why stakeholders might be important to a project or campaign? Select all that apply.
A
Stakeholders coordinate marketing activities and initiatives.
B
Stakeholders often analyze the data from a campaign.
C
Stakeholders strongly influence the success of a project or campaign.Correct Answer
D
Stakeholders often fund projects or operate budgets for campaigns.Correct Answer
QUESTION 2 OF 52
Which of the following might be reasons to create a stakeholder map? Select all that apply.
A
To help coordinate marketing activities and initiatives and identify target audiences through research
B
To allow for people to better manage stakeholders’ expectations and avoid information overloadCorrect Answer
C
To help people work effectively without having the process consume too much of their time or energyCorrect Answer
D
To make it easier to identify the type and amount of interaction needed to maintain each stakeholderCorrect Answer
QUESTION 3 OF 52
Which of the following are spreadsheet features that support preparing data to be shared? Select all that apply.
A
Acquiring
B
Pivot tables (CORRECT
C
SortingCorrect Answer
D
FilteringCorrect Answer
QUESTION 4 OF 52
What is the purpose of a pivot table?
A
Pivot tables display individual measurements in a vertical column.
B
Pivot tables display how a metric changes over an extended time connected with a continuous line.
C
Pivot tables change the view of data in a spreadsheet to a different perspective to categorize it, or to identify an insight or trend.Correct Answer
D
Pivot tables display individual data points that have been categorized into ranges, with the frequency of each range represented by the height of a unique column.
QUESTION 5 OF 52
Which of the following visualizations shows individual data points that have been categorized into ranges, with the frequency of each range represented by the height of a unique column?
A
pivot table
B
spreadsheet
C
histogramCorrect Answer
D
pie chart
QUESTION 6 OF 52
A marketer is creating a presentation using marketing analytics data. How can they use data to lead their audience to agree with their final conclusion? Select all that apply.
A
Include all the data collected about the topic of their presentation
B
Omit most of the data collected and put together a short presentation
C
Include the most relevant metrics that led to their insightsCorrect Answer
D
Develop a clear outline or flow for their presentationCorrect Answer
QUESTION 7 OF 52
On a marketing team, who is responsible for running campaigns, identifying target audiences through research, and evaluating trends?
A
Stakeholder
B
Customer service agent
C
Marketing coordinatorCorrect Answer
D
Sales manager
QUESTION 8 OF 52
Which of the following would enable a data analyst to communicate with databases developed by different vendors and hosted on multiple platforms?
A
Structured query languageCorrect Answer
B
Spreadsheets
C
Filtering
D
Sorting
QUESTION 9 OF 52
Which of the following resources help marketers visualize data with custom reports and dashboards? Select all that apply.
A
Google Sheets
B
Microsoft Excel
C
Google Data StudioCorrect Answer
D
TableauCorrect Answer
QUESTION 10 OF 52
Imagine a marketer is working on a campaign and wants to request a change to the budget. Which of the following presentation best practices should they use to get this change approved by stakeholders? Select all that apply.
A
Do not allow any time for questions
B
Start with a general status of the campaign and then move on to the specifics of making a change to the budgetCorrect Answer
C
Create visualizations of the data using titles that relate back to the insightsCorrect Answer
D
End the presentation with changing the budget as a call to action for stakeholdersCorrect Answer
QUESTION 11 OF 52
Which of the following are important to understand when interacting with a stakeholder about a project? Select all that apply.
A
What the stakeholder thinks about project team members on the project
B
Which communication methods a stakeholder prefersCorrect Answer
C
The stakeholder’s interest in the project and what their needs areCorrect Answer
D
When to communicate with a stakeholderCorrect Answer
QUESTION 12 OF 52
Imagine that a marketer is working with a dataset in a spreadsheet. They want to view the data from a new perspective to help them categorize it and identify insights or trends. What spreadsheet tool should they use?
A
Data visualization
B
Values
C
Pivot tableCorrect Answer
D
Columns
QUESTION 13 OF 52
Which of the following charts represents data in the same way as a line chart, but with the space under the line filled in to form a visual area?
A
Histogram
B
Area chartCorrect Answer
C
Horizontal bar chart
D
Pie chart
QUESTION 14 OF 52
Which of the following tasks would a marketing coordinator be responsible for? Select all that apply.
A
Applying statistical methods to data
B
Identifying target audiences through researchCorrect Answer
C
Running campaignsCorrect Answer
D
Evaluating trendsCorrect Answer
QUESTION 15 OF 52
Which of the following is a visual analytics platform that makes it easier to explore and manage data, and to create custom dashboards that incorporate different data visualizations in one place?
A
Google Sheets
B
TableauCorrect Answer
C
Microsoft Office
D
PowerPoint
QUESTION 16 OF 52
Which of the following are considered best practices when creating slides for a presentation? Select all that apply.
A
Progress from specific to general topics
B
Repeat the insights when presenting the relevant, supporting dataCorrect Answer
C
Introduce data visualizations using titles that relate back to the insightsCorrect Answer
D
Allow time for questions so the audience can reach the same conclusionCorrect Answer
QUESTION 17 OF 52
Which of the following describes the relationship between stakeholders and marketing coordinators?
A
Stakeholders collect data, apply statistical methods, and create data visualization. Marketing coordinators identify target audiences through research, run campaigns, and evaluate trends.
B
Marketing coordinators collect data, apply statistical methods, and create data visualization. Stakeholders identify target audiences through research, run campaigns, and evaluate trends.
C
Marketing coordinators fund projects and ensure a project’s success. Stakeholders keep the marketing coordinator informed about a project’s progress, ongoing metrics, and insights.
D
Stakeholders fund projects and ensure a project’s success. Marketing coordinators keep stakeholders informed about a project’s progress, ongoing metrics, and insights.Correct Answer
QUESTION 18 OF 52
Which of the following visualizations includes individual data points for a changing variable connected by a continuous line?
A
line chartCorrect Answer
B
single column chart
C
vertical bar chart
D
pie chart
QUESTION 19 OF 52
Fill in the blank A _____ could blend a marketing coordinator and a data analyst role into a single marketing specialist role.
A
stakeholder role
B
new role
C
hybrid roleCorrect Answer
D
traditional role
QUESTION 20 OF 52
Which method keeps track of the influence and needs of stakeholders and the level of communication required to keep them informed?
A
Newsletter
B
Stakeholder mapCorrect Answer
C
Histogram
D
Pivot table
QUESTION 21 OF 52
On a marketing team, who is responsible for running database queries, applying statistical methods to data, and creating data visualizations?
A
Human resources representative
B
Data analystCorrect Answer
C
Accountant
D
Customer service agent
QUESTION 22 OF 52
Which of the following best describes a stakeholder?
A
Someone who sells products or services for a company
B
Someone who strongly influences the success of a project or campaign through fundingCorrect Answer
C
Someone who analyzes marketing data
D
Someone who purchases products or services from a company
QUESTION 23 OF 52
How do marketers and stakeholders work together?
A
Marketers access data to create campaigns. Stakeholders advise on creative assets.
B
Stakeholders have access to data that marketers do not. Marketers receive data from stakeholders to create campaigns.
C
Marketers summarize campaign data and inform stakeholders of a campaign’s progress. Stakeholders fund campaigns and have an interest in their success.Correct Answer
D
Stakeholders set goals and KPIs for a campaign. Marketers fund campaigns to reach the goals.
QUESTION 24 OF 52
Why would a marketer sort data in a spreadsheet?
A
It helps them automatically remove irrelevant data.
B
It helps them find new patterns and relationships within data sets.Correct Answer
C
It helps them display data that match specific criteria.
D
It helps them present campaign data with visualizations.
QUESTION 25 OF 52
What are the three main fields used to categorize data in a pivot table?
A
Function, Name, Menu
B
Rows, Columns, ValuesCorrect Answer
C
Display, Columns, Filter
D
Filter, Units, Rows
QUESTION 26 OF 52
Fill in the blank A benefit of _____ is that you can easily copy and paste them into slides when you need to share data insights with others.
A
spreadsheet chartsCorrect Answer
B
vertical columns
C
campaign assets
D
marketing plans
QUESTION 27 OF 52
Which of the following guidelines should a marketer follow when working with stakeholders in a marketing campaign?
A
Understand why the stakeholder is interested in the campaignCorrect Answer
B
Identify which team members the stakeholder has worked with before
C
Provide limited information to the stakeholder to manage their expectations
D
Create a map to understand previous campaign stakeholders
QUESTION 28 OF 52
A marketer determines what type of interaction each stakeholder requires from them during a campaign. What visual assistance helps them gather this information?
A
Stakeholder dashboard
B
Budget dashboard
C
Stakeholder mapCorrect Answer
D
Campaign overview
QUESTION 29 OF 52
A marketer uses a chart to compare two variables side-by-side. The chart displays each variable as a bar. What type of chart did the marketer create?
A
Pivot chart
B
Histogram
C
Vertical column chartCorrect Answer
D
Line chart
QUESTION 30 OF 52
Which of the following is an example of a way a pie chart can be used to represent data?
A
Represent individual data points for a changing variable connected with a continuous line
B
Represent individual data points categorized into ranges, with the frequency of each range represented by the height of a unique column
C
Represent a large spike in new users with a horizontal bar
D
Represent percentages of data in sections, all adding up to one hundred percentCorrect Answer
QUESTION 31 OF 52
A business hires someone to analyze data and create and monitor marketing campaigns. What is this role known as?
A
Data specialist role
B
Marketing coordinator role
C
Hybrid roleCorrect Answer
D
Data analyst
QUESTION 32 OF 52
An e-commerce business hires someone to organize its marketing activities and initiatives. Who is typically responsible for these tasks?
A
A marketing coordinatorCorrect Answer
B
A data specialist
C
A marketing analyst
D
A marketing strategist
QUESTION 33 OF 52
Why would a marketer create a data dashboard?
A
To analyze data and create visualizations for statistical calculations
B
To communicate with databases developed by different vendors on multiple platforms
C
To track, analyze, and display KPIs, metrics, and real-time data in a centralized viewCorrect Answer
D
To create and manage large data sets and analyze custom data visualizations
QUESTION 34 OF 52
A marketer uses a graph to show how a metric changes over an extended period. The chart displays a connected series of data points. What type of chart did the marketer create?
A
Vertical column chart
B
Horizontal bar chart
C
Histogram
D
Line chartCorrect Answer
QUESTION 35 OF 52
When would you use a horizontal bar chart instead of a vertical column chart?
A
To compare how one metric changes over time in a single column
B
To compare two metrics side-by-side in a column
C
To compare measurements with a significant differenceCorrect Answer
D
To compare how a metric or variable changes
QUESTION 36 OF 52
What programming language allows you to access large databases for analysis?
A
SQLCorrect Answer
B
Data Studio
C
Tableau
D
Search console
QUESTION 37 OF 52
Which three steps should you follow when creating an effective presentation using marketing analytics?
A
Learn about stakeholders, include all campaign data in the presentation, and use an interactive template
B
Introduce data visualizations, include all campaign data, and share insights at the end of the presentation
C
Develop a clear outline of the presentation, choose the correct data, and include the most relevant metricsCorrect Answer
D
Find an interactive template, gather insights from previous campaigns, and include all metrics
QUESTION 38 OF 52
What role do stakeholders typically play in a campaign?
A
Stakeholders approve the creative used in a campaign.
B
Stakeholders track and analyze data about a campaign’s success.
C
Stakeholders fund a project or manage a campaign budget.Correct Answer
D
Stakeholders create campaigns and related social media efforts.
QUESTION 39 OF 52
Why would a marketer create a stakeholder map?
A
To help organize stakeholders into a graph according to their budget and experience with campaigns
B
To determine which stakeholder is a reliable source for campaign queries and obstacles
C
To identify which stakeholder is the most influential and to share frequent updates with them
D
To help manage stakeholder expectations and effectively share relevant information with themCorrect Answer
QUESTION 40 OF 52
What feature can a marketer use to hide data in a pivot table?
A
Columns
B
FilterCorrect Answer
C
Sort
D
Values
QUESTION 41 OF 52
When would a marketing team use Tableau?
A
To track, analyze, and display KPIs, metrics, and insights in a centralized view
B
To access and manage large databases, gather insights, and create visualizationsCorrect Answer
C
To create KPIs and metrics for a real-time interactive dashboard
D
To learn coding or programming skills to create interactive visualizations
QUESTION 42 OF 52
A marketer is working with a spreadsheet. What can they do to display only data that meets a certain condition and hide all non-matching data?
A
Delete the data that does not match
B
Sort the data in ascending order
C
Copy and paste the data
D
Filter the data in a columnCorrect Answer
QUESTION 43 OF 52
How is an area chart different from a line chart?
A
The space under the line is shaded in with colors or textures.Correct Answer
B
Area charts can only be single or stacked.
C
Area charts can show data with partial and whole results.
D
The changing variable connects on a continuous line.
QUESTION 44 OF 52
Why would an e-commerce business hire a marketing coordinator?
A
To design visual assets for campaigns, print ads, and create websites
B
To manage the company’s social media accounts
C
To collect data, query databases, and create data visualizations
D
To identify target audiences, create campaigns, and evaluate trendsCorrect Answer
QUESTION 45 OF 52
An e-commerce business hires someone to collect and analyze data as well as create visualizations. What role does this describe?
A
Marketing coordinator
B
Data analystCorrect Answer
C
Graphic designer
D
Project manager
QUESTION 46 OF 52
A data analyst uses visual analytics software to analyze data and create unique dashboards and visualizations. What software does this refer to?
A
Python
B
SQL
C
R
D
TableauCorrect Answer
QUESTION 47 OF 52
Which of the following is a best practice when creating slides for a presentation?
A
Use generic titles for data visualizationsCorrect Answer
B
Include all data you collected
C
End the presentation with the most surprising insight
D
Progress from general to specific topics
QUESTION 48 OF 52
A marketer shares campaign insights with a director because the director funds the campaign and plans to make decisions based on its results. What is likely the director’s role in the campaign?
A
Marketer
B
Data analyst
C
StakeholderCorrect Answer
D
Campaign advisor
QUESTION 49 OF 52
In which of the following scenarios would a horizontal bar chart be most useful?
A
To save space because there is a large difference between the measurements being comparedCorrect Answer
B
To show data points categorized into ranges, with the frequency represented by the height of a unique column
C
To show how a metric changes over an extended period of time
D
To show data that has partial and whole results
QUESTION 50 OF 52
A marketing team member queries databases, applies statistical methods to data, and creates data visualizations. What role does this describe?
A
Copywriter
B
Stakeholder
C
Data analystCorrect Answer
D
Office manager
QUESTION 51 OF 52
A marketer is working with a spreadsheet. What can they do to uncover new patterns and relationships within datasets that they might miss otherwise?
A
Copy data
B
Sort dataCorrect Answer
C
Acquire data
D
Input data
QUESTION 52 OF 52
Which of the following changes your view of data in a spreadsheet to a different perspective to categorize it, or to identify an insight or trend?
A
Pivot tableCorrect Answer
B
Histogram
C
Area table
D
Spreadsheet
Ready to test your recall?
Which of the following are reasons why stakeholders might be important to a project or campaign? Select all that apply.
💡Select all 2 correct answers before submitting (0 of 2 selected).
A
Stakeholders coordinate marketing activities and initiatives.
B
Stakeholders often analyze the data from a campaign.
C
Stakeholders strongly influence the success of a project or campaign.
D
Stakeholders often fund projects or operate budgets for campaigns.