WGU D465
Which task is an analyst performing in a
spreadsheet when they isolate data that Filtering Data
meets specific, exclusive criteria?
Which command should an analyst use
to identify which table to access in a
FROM
database using a Structured Query Lan-
guage (SQL)?
How can an analyst sort all areas
of Microsoft Excel and Google Sheets
"sort sheet"
spreadsheets to organize data for analy-
sis?
Which method can an analyst use to cat-
egorize data based on a specific metric
Write a sort function
in Microsoft Excel and Google Sheets
spreadsheets for data analysis?
An analyst needs to manipulate and cat-
egorize data using a spreadsheet and
Structured Query Language (SQL).How Sort and Filter data
can they format and adjust data for
analysis?
How does an analyst reorganize the lay-
out of data in Microsoft Excel or Google
SORT function
Sheets spreadsheets based on product
type while keeping all rows visible?
How does a pivot table custom list sort
In ascending order first
by default for analysis?
An analyst is working with data in a
Google Sheet spreadsheet that lists tem-
peratures in Fahrenheit but needs the Use the CONVERT function
data to be in Celsius.How can the analyst
change the unit of measurement?
An analyst is working with a Microsoft
Excel spreadsheet that will later be
shared with a project team.Why would To control the type of data entered
the analyst use the validation function on
this sheet?
, WGU D465
An analyst wants to format all data
in a column to YYYY-MM-DD format
to be represented by dates and times
with values ranging from 00:00:00 to Data will be converted to a datetime val-
11:59:59 using Structured Query Lan- ue.
guage (SQL). The analyst uses the
DATETIME command. What does this
command do to the data?
Why does an analyst use the LEN
function in Microsoft Excel and Google To determine the length of a string
Sheets spreadsheets?
Why does an analyst use the CON-
To add two or more strings together with
CAT_WS function in Structured Query
a separator
Language (SQL)?
Which programming language can han-
dle trillions of rows of data and is now a
Structured Query Language (SQL)
standard language for working with data-
base programs?
An analyst is working on a project with
a lot of milestones to track and wants
to create a spreadsheet that every- Create a data validation menu in cells
one can use to track their individual with predetermined options
progress.How could the analyst sort and
filter progress milestones?
An analyst working with data in two dif-
ferent Google Sheets needs information
from both spreadsheets to connect to-
VLOOKUP
gether in a matching column on a single
sheet.Which function should the analyst
use?
An analyst working to aggregate data
in databases uses a Structured Query
Language (SQL) command that returns
INNER JOIN
all matching records in two tables and
the key values in each.Which command
has the analyst used?
Which task is an analyst performing in a
spreadsheet when they isolate data that Filtering Data
meets specific, exclusive criteria?
Which command should an analyst use
to identify which table to access in a
FROM
database using a Structured Query Lan-
guage (SQL)?
How can an analyst sort all areas
of Microsoft Excel and Google Sheets
"sort sheet"
spreadsheets to organize data for analy-
sis?
Which method can an analyst use to cat-
egorize data based on a specific metric
Write a sort function
in Microsoft Excel and Google Sheets
spreadsheets for data analysis?
An analyst needs to manipulate and cat-
egorize data using a spreadsheet and
Structured Query Language (SQL).How Sort and Filter data
can they format and adjust data for
analysis?
How does an analyst reorganize the lay-
out of data in Microsoft Excel or Google
SORT function
Sheets spreadsheets based on product
type while keeping all rows visible?
How does a pivot table custom list sort
In ascending order first
by default for analysis?
An analyst is working with data in a
Google Sheet spreadsheet that lists tem-
peratures in Fahrenheit but needs the Use the CONVERT function
data to be in Celsius.How can the analyst
change the unit of measurement?
An analyst is working with a Microsoft
Excel spreadsheet that will later be
shared with a project team.Why would To control the type of data entered
the analyst use the validation function on
this sheet?
, WGU D465
An analyst wants to format all data
in a column to YYYY-MM-DD format
to be represented by dates and times
with values ranging from 00:00:00 to Data will be converted to a datetime val-
11:59:59 using Structured Query Lan- ue.
guage (SQL). The analyst uses the
DATETIME command. What does this
command do to the data?
Why does an analyst use the LEN
function in Microsoft Excel and Google To determine the length of a string
Sheets spreadsheets?
Why does an analyst use the CON-
To add two or more strings together with
CAT_WS function in Structured Query
a separator
Language (SQL)?
Which programming language can han-
dle trillions of rows of data and is now a
Structured Query Language (SQL)
standard language for working with data-
base programs?
An analyst is working on a project with
a lot of milestones to track and wants
to create a spreadsheet that every- Create a data validation menu in cells
one can use to track their individual with predetermined options
progress.How could the analyst sort and
filter progress milestones?
An analyst working with data in two dif-
ferent Google Sheets needs information
from both spreadsheets to connect to-
VLOOKUP
gether in a matching column on a single
sheet.Which function should the analyst
use?
An analyst working to aggregate data
in databases uses a Structured Query
Language (SQL) command that returns
INNER JOIN
all matching records in two tables and
the key values in each.Which command
has the analyst used?
