WGU D465 -PA DATA APPLICATIONS QUESTIONS AND ANSWERS
1. Which task is an analyst performing in a
spreadsheet when they isolate data that meets
specific, exclusive criteria?: Filtering Data
2. Which command should an analyst use to
identify which table to access in a database using
a Structured Query Language (SQL)?: FROM
3. How can an analyst sort all areas of Microsoft
Excel and Google Sheets spreadsheets to
organize data for analysis?: "Sort Sheet"
4. Which method can an analyst use to categorize
data based on a specific met-ric in Microsoft Excel
and Google Sheets spreadsheets for data analysis?:
Write
a sort function
,5. An analyst needs to manipulate and categorize
data using a spreadsheet and Structured Query
Language (SQL).
How can they format and adjust data for analysis?: Sort
and filter data
6. How does an analyst reorganize the layout of
data in Microsoft Excel or Google Sheets
spreadsheets based on product type while
keeping all rows visible?: SORT function
7. How does a pivot table custom list sort by default for
analysis?: in ascending order
first
8. An analyst is working with data in a Google
Sheet spreadsheet that lists temperatures in
Fahrenheit but needs the data to be in Celsius.
How can the analyst change the unit of measurement?:
Use the CONVERT function
9. An analyst is working with a Microsoft Excel
spreadsheet that will later be shared with a
project team. Why would the analyst use the
validation function on this sheet?: to control the type of
data entered
10. 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
11:59:59 using Structured Query Language (SQL).
The analyst uses the DATETIME command.
What does this command do to the data?: Data will be
converted to a datetime value.
11. Why does an analyst use the LEN function in
Microsoft Excel and Google Sheets spreadsheets?: To
determine the length of a string
12. Why does an analyst use the CONCAT_WS
function in Structured Query Language (SQL)?: To add
two or more strings together with a separator
1. Which task is an analyst performing in a
spreadsheet when they isolate data that meets
specific, exclusive criteria?: Filtering Data
2. Which command should an analyst use to
identify which table to access in a database using
a Structured Query Language (SQL)?: FROM
3. How can an analyst sort all areas of Microsoft
Excel and Google Sheets spreadsheets to
organize data for analysis?: "Sort Sheet"
4. Which method can an analyst use to categorize
data based on a specific met-ric in Microsoft Excel
and Google Sheets spreadsheets for data analysis?:
Write
a sort function
,5. An analyst needs to manipulate and categorize
data using a spreadsheet and Structured Query
Language (SQL).
How can they format and adjust data for analysis?: Sort
and filter data
6. How does an analyst reorganize the layout of
data in Microsoft Excel or Google Sheets
spreadsheets based on product type while
keeping all rows visible?: SORT function
7. How does a pivot table custom list sort by default for
analysis?: in ascending order
first
8. An analyst is working with data in a Google
Sheet spreadsheet that lists temperatures in
Fahrenheit but needs the data to be in Celsius.
How can the analyst change the unit of measurement?:
Use the CONVERT function
9. An analyst is working with a Microsoft Excel
spreadsheet that will later be shared with a
project team. Why would the analyst use the
validation function on this sheet?: to control the type of
data entered
10. 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
11:59:59 using Structured Query Language (SQL).
The analyst uses the DATETIME command.
What does this command do to the data?: Data will be
converted to a datetime value.
11. Why does an analyst use the LEN function in
Microsoft Excel and Google Sheets spreadsheets?: To
determine the length of a string
12. Why does an analyst use the CONCAT_WS
function in Structured Query Language (SQL)?: To add
two or more strings together with a separator
