GOOGLE DATA ANALYTICS
PROFESSIONAL CERTIFICATE EXAM
QUESTIONS WITH CORRECT
ANSWERS
function - Answer-A preset command that automatically performs a specified process
or task using data in a spreadsheet.
Header - Answer-The first row in a spreadsheet that labels the type of data in a
column.
leading question - Answer-A question that steers people toward a certain response
math expression - Answer-A calculation that involves addition, subtraction,
multiplication, or division (also called an equation)
Math functions - Answer-A function the is used as part of a mathematical formula
MAX - Answer-A spreadsheet function that returns the largest numeric value in a
range of cells.
Measurable question - Answer-A question whose answers can be quantified and
assessed
metric - Answer-A single, quantifiable type of data that is used for measurement
Metric goal - Answer-A measurable goal set by a company and evaluated using
metrics
MIN - Answer-A spreadsheet function that returns the smallest numeric value for a
range of cells.
Pivot Chart - Answer-A chart created from the fields in a pivot table
Observation - Answer-The attributes that describe a piece of data contained in a row
of a table
Open data - Answer-Data that is available to the public.
Order of operations - Answer-Using parentheses to group together spreadsheet
values in order to clarify the order in which operations should be performed.
problem domain - Answer-The area of analysis the encompasses every activity
affecting or affected by a problem.
, Problem types - Answer-The various problems that data analysts encounter,
including categorizing things, discovering connections, finding patterns, identifying
themes, making predictions, and spotting something unusual
range - Answer-A collection of two or more cells in a spreadsheet
Relevant questions - Answer-A question that has significance to the problem to be
solved.
Scope of Work (SOW) - Answer-An agreed-upon outline of the tasks to be performed
during a project
SUM - Answer-A spreadsheet function that adds values to a selected range of cells.
Time-bound question - Answer-A question that specifies a timeframe to be studied
Unfair question - Answer-A question that makes assumptions or is difficult to answer
honestly.
First Party Data - Answer-Data collected by an individual or group using their own
resources
Second Party Data - Answer-Data collected by a group directly from its audience and
then sold
third party data - Answer-Data provided from outside sources who didn't collect it
directly
discrete data - Answer-Data that is counted and has a limited number of values
continuous data - Answer-Data that is measured and can have almost any numeric
value
Formula - Answer-A set of instructions that perform a specific action using the data
in a spreadsheet
Fairness - Answer-Ensuring that your analysis doesn't create or reinforce bias
Business task - Answer-The question or problem data analysis answers for a
business
query - Answer-a request for information from a database
Observation - Answer-The attributes that describe a piece of data contained in a row
of a table
Structured thinking - Answer-The process of recognizing the current problem or
situation, organizing available information, revealing gaps and opportunities, and
identifying options.
PROFESSIONAL CERTIFICATE EXAM
QUESTIONS WITH CORRECT
ANSWERS
function - Answer-A preset command that automatically performs a specified process
or task using data in a spreadsheet.
Header - Answer-The first row in a spreadsheet that labels the type of data in a
column.
leading question - Answer-A question that steers people toward a certain response
math expression - Answer-A calculation that involves addition, subtraction,
multiplication, or division (also called an equation)
Math functions - Answer-A function the is used as part of a mathematical formula
MAX - Answer-A spreadsheet function that returns the largest numeric value in a
range of cells.
Measurable question - Answer-A question whose answers can be quantified and
assessed
metric - Answer-A single, quantifiable type of data that is used for measurement
Metric goal - Answer-A measurable goal set by a company and evaluated using
metrics
MIN - Answer-A spreadsheet function that returns the smallest numeric value for a
range of cells.
Pivot Chart - Answer-A chart created from the fields in a pivot table
Observation - Answer-The attributes that describe a piece of data contained in a row
of a table
Open data - Answer-Data that is available to the public.
Order of operations - Answer-Using parentheses to group together spreadsheet
values in order to clarify the order in which operations should be performed.
problem domain - Answer-The area of analysis the encompasses every activity
affecting or affected by a problem.
, Problem types - Answer-The various problems that data analysts encounter,
including categorizing things, discovering connections, finding patterns, identifying
themes, making predictions, and spotting something unusual
range - Answer-A collection of two or more cells in a spreadsheet
Relevant questions - Answer-A question that has significance to the problem to be
solved.
Scope of Work (SOW) - Answer-An agreed-upon outline of the tasks to be performed
during a project
SUM - Answer-A spreadsheet function that adds values to a selected range of cells.
Time-bound question - Answer-A question that specifies a timeframe to be studied
Unfair question - Answer-A question that makes assumptions or is difficult to answer
honestly.
First Party Data - Answer-Data collected by an individual or group using their own
resources
Second Party Data - Answer-Data collected by a group directly from its audience and
then sold
third party data - Answer-Data provided from outside sources who didn't collect it
directly
discrete data - Answer-Data that is counted and has a limited number of values
continuous data - Answer-Data that is measured and can have almost any numeric
value
Formula - Answer-A set of instructions that perform a specific action using the data
in a spreadsheet
Fairness - Answer-Ensuring that your analysis doesn't create or reinforce bias
Business task - Answer-The question or problem data analysis answers for a
business
query - Answer-a request for information from a database
Observation - Answer-The attributes that describe a piece of data contained in a row
of a table
Structured thinking - Answer-The process of recognizing the current problem or
situation, organizing available information, revealing gaps and opportunities, and
identifying options.
